ObjectContext ConnectionString Sqlite

Question

I need to connect to a database in Sqlite so i downloaded and installed System.Data.SQLite and with the designer dragged all my tables.

The designer created a .cs file with

public class Entities : ObjectContext

and 3 constructors:

1st

public Entities() : base("name=Entities", "Entities")

this one load the connection string from App.config and works fine.

App.config

<connectionStrings>
    <add name="Entities" connectionString="metadata=res://*/Db.TracModel.csdl|res://*/Db.TracModel.ssdl|res://*/Db.TracModel.msl;provider=System.Data.SQLite;provider connection string=&quot;data source=C:\Users\Filipe\Desktop\trac.db&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

2nd

public Entities(string connectionString) : base(connectionString, "Entities")

3rd

public Entities(EntityConnection connection) : base(connection, "Entities")

Here is the problem, i already tried n configuration, already used EntityConnectionStringBuilder to make the connection string with no luck.

Can you please point me in the right direction!?

EDIT(1)

I can do my queries if i use de parameterless constructor but i need to change the connection string, i can't use the one in my app.config.

How can i construct a valid connection string?!

codegarten · Accepted Answer · 2010-05-19 09:28:57Z

7

Found it =)

if you use the EntityConnectionStringBuilder to specify the Metadataand the Provider and use the SqlConnectionStringBuilderto build the provider connection string and set the DataSource to your DB. You can connect =)

var con = new EntityConnectionStringBuilder()
  {
    Metadata = @"res://*/Db.TracModel.csdl|res://*/Db.TracModel.ssdl|res://*/Db.TracModel.msl",
    Provider = @"System.Data.SQLite",
    ProviderConnectionString = new SqlConnectionStringBuilder()
      {
        DataSource = db,
      }.ConnectionString,
  };

connection = con.ConnectionString;

answered May 19, 2010 at 9:28

codegarten

1971 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

ObjectContext ConnectionString Sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related