[sqlite] System.Data.SQLite

[Lloyd]

Hi,

I am trying to use SQLite with EntityFramework6 on a .Net application.

I have referred the documentation, created the app.config file as specified
in the documentation. When I created a sample C# file as in the
documentation,it generates an empty database file.

DbProviderFactory fact =
DbProviderFactories.GetFactory("System.Data.SQLite");
using (DbConnection cnn = fact.CreateConnection())
{
  cnn.ConnectionString = "Data Source=test.db3";
  cnn.Open();
}

How can I associate a DBContext with this connection? Is it possible to
create tables in my sqlite database based on my entity classes?

I couldn't find any tutorial on using System.Data.SQLite with Entity
Framework.

Any hint/help/a link to tutorial is greatly appreciated

Thanks,
  Lloyd
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users