Guest User

Untitled

a guest
Jul 20th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1. class Person
  2. {
  3. [Key]
  4. public int ID { get; set; }
  5. public string Name { get; set; }
  6. }
  7.  
  8. class MyDBContentext : DbContext
  9. {
  10. public MyDBContentext(string connectionString)
  11. : base(new SQLiteConnection() { ConnectionString = connectionString }, true)
  12. { }
  13.  
  14. protected override void OnModelCreating(DbModelBuilder modelBuilder)
  15. {
  16. var sqliteConnectionInitializer = new SqliteCreateDatabaseIfNotExists<MyDBContentext>(modelBuilder);
  17. System.Data.Entity.Database.SetInitializer(sqliteConnectionInitializer);
  18. }
  19.  
  20. public DbSet<Person> People { get; set; }
  21. }
  22.  
  23. //main
  24. var conStr = $"Data Source=eftest.sqlite;Version=3;Password=123;";
  25. var ctx = new MyDBContentext(conStr);
  26. ctx.People.Add(new Person() { Name = "foo" });//<--- exception throw here
  27. var res = ctx.SaveChanges();
  28.  
  29. <system.data>
  30. <DbProviderFactories>
  31. <remove invariant="System.Data.SQLite.EF6" />
  32. <add name="SQLite Data Provider (Entity Framework 6)"
  33. invariant="System.Data.SQLite.EF6"
  34. description=".NET Framework Data Provider for SQLite (Entity Framework 6)"
  35. type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
  36. <remove invariant="System.Data.SQLite" />
  37. <add name="SQLite Data Provider" invariant="System.Data.SQLite"
  38. description=".Net Framework Data Provider for SQLite"
  39. type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
  40. </DbProviderFactories>
  41. </system.data>
  42. <entityFramework>
  43. <providers>
  44. <provider invariantName="System.Data.SQLite.EF6"
  45. type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
  46. <provider invariantName="System.Data.SqlClient"
  47. type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
  48. <provider invariantName="System.Data.SQLite"
  49. type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
  50. </providers>
  51. </entityFramework>
Add Comment
Please, Sign In to add comment