2

in App.Config file :

<connectionStrings>
    <add name="DB_PhonebookEntities" connectionString="metadata=res://*/MyModel.csdl|res://*/MyModel.ssdl|res://*/MyModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.;Initial Catalog=DB_Phonebook;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

in MyModel.Designer.cs file :

namespace SimplePhoneBook
{
    public partial class DB_PhonebookEntities : ObjectContext
    {            
        public DB_PhonebookEntities() : base("name=DB_PhonebookEntities", "DB_PhonebookEntities")
        {            
            ....
        }

        public DB_PhonebookEntities(string connectionString): base(connectionString, "DB_PhonebookEntities") 
        {
            ....
        }

        public DB_PhonebookEntities(EntityConnection connection) : base(connection, "DB_PhonebookEntities")
        {
            ....
        }

        ....        
    }

How can I set Application.StartupPath into my ConnectionString?

Tolga Evcimen
  • 7,112
  • 11
  • 58
  • 91
behzad alizadeh
  • 31
  • 5
  • 2
    You can't. Why do you want to do that? – Patrick Hofman Dec 03 '14 at 12:34
  • Just leave it as is, instead, at runtime use the [EntityConnectionStringBuilder](http://msdn.microsoft.com/en-us/library/system.data.entityclient.entityconnectionstringbuilder(v=vs.110).aspx) in your code to fix the parts that are not valid. – Steve Dec 03 '14 at 12:38
  • What exactly do you mean by "set "Application.StartupPath" into my ConnectionString", what part of the value returned by `Application.StartupPath` is usefull when setting a connection string. – Ben Robinson Dec 03 '14 at 12:40
  • possible duplicate of [ADO.NET |DataDirectory| where is this documented?](http://stackoverflow.com/questions/1409358/ado-net-datadirectory-where-is-this-documented) – Panagiotis Kanavos Dec 03 '14 at 12:54
  • You would only need a specific path if your connection string was trying to attach a file but your connection string connects to a server. Even then, you can configure the `DataDirectory` in code – Panagiotis Kanavos Dec 03 '14 at 12:58
  • For the sqlite database, i have solved this problem, if you have not fixed yet let me know – r.hamd Apr 06 '16 at 07:31

2 Answers2

0

I want create "Model" from my database thais on the applicatin path(...\debug\bin\mydatabase.mdf)

and using entities in my model!

behzad alizadeh
  • 31
  • 5
0

Append this to your connection string. This will point to WebApplication1\App_Data. So your mdf file should be in App_Data folder

AttachDBFilename=|DataDirectory|\aspnet-WebApplication1-20141203171438.mdf
Mahesh Malpani
  • 1,782
  • 16
  • 27