Through DBContext constructor I have associated the connection. As the
table is not existing in my database, it throws an exception. Does sqlite
support automatic creation of tables or do I have create the tables and
relationships first and then insert the data using the framework?
On Fri, Aug 19, 2016 at 6:02 PM, Lloyd <lloydkl.t...@gmail.com> wrote:
> 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
