How to use EF Code-First without an app.conf file?

Question

If I use an app.conf file to define the connection for a SQL CE 4.0 DB, my app works fine.

How can I "initialize the connection" (hope this is the right term...) without an app.conf, in the code?

Here is what I have so far (not much):

SqlCeConnectionStringBuilder builder = new SqlCeConnectionStringBuilder();
builder["Data Source"] = "db.sdf";               

//What is missing here?

PartyDB DB = new PartyDB();

var dinners = from d in DB.Dinners                        
              select d;

Any hint is highly appreciated.

PengOne · Accepted Answer · 2011-09-20 22:59:50Z

5

J. Tihon's answer helped me. I am adding the following for future reference. I initialized the Database.DefaultConnectionFactory in the constructor.

public partial class MyDb: DbContext
{
    public static string Connection
    {
        get
        {

            var result = new SqlCeConnectionStringBuilder();

            result["Data Source"] = "MyDatabaseFile.sdf";

            return result.ToString();
        }
    }

    public MyDb()
        : base(Connection)
    {
        Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0");
    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {

    }

    public DbSet<MyTable> MyTable { get; set; }

}

edited Sep 20, 2011 at 22:59

PengOne

48.4k17 gold badges132 silver badges152 bronze badges

answered Sep 20, 2011 at 17:24

Miguel-.o

1781 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

J. Tihon · Accepted Answer · 2011-07-08 18:53:31Z

3

There are various method of instantiating a DbContext (which your PartyDb probably derives from). I recommend you take a look at this blog-post. For you specific problem, this paragraph from the blog-post should fit:

You can pass a full connection string to DbContext instead of just the database or connection string name. By default this connection string is used with the System.Data.SqlClient provider; this can be changed by setting a different implementation of IConnectionFactory onto context.Database.DefaultConnectionFactory.

answered Jul 8, 2011 at 18:53

J. Tihon

4,45926 silver badges19 bronze badges

1 Comment

Mike Over a year ago

Thanks for the link! :-) The solution I found on this site works: Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0");

Eli Ein-Dor · Accepted Answer · 2016-09-04 11:16:41Z

0

If you have oracle provider and all the answers didn"t help try this: Changing the app.config entry in entityFramework**defaultConnectionFactory** to

type="Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory, Oracle.ManagedDataAccess.EntityFramework" ......

Now all you need to send to the constructore is a regular connection string:

public partial class MyModel : DbContext { public MyModel(String ConnectionString) : base(ConnectionString) { } ..........

answered Sep 4, 2016 at 11:16

Eli Ein-Dor

1

Collectives™ on Stack Overflow

How to use EF Code-First without an app.conf file?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related