EF SQLite：使用Entity Framework的SQLite支持

• 1.首先，我们需要在Visual Studio中打开我们的项目。
• 2.接下来，我们需要通过NuGet包管理器来安装EF SQLite。

  • Install-Package System.Data.SQLite.EF6

• 3.安装完毕后，我们需要在App.config或web.config文件中设置SQLite的连接字符串。
  •   <connectionStrings>
        <add name="SQLiteConnection" connectionString="data source=.\Data.db" providerName="System.Data.SQLite.EF6" />
      </connectionStrings>
• 配置文件新增节点  entityFramework 中添加
  • <providers>
          
          <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
          <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
          <provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
        </providers>
• system.data 中添加如下代码
  •   <system.data>
        <DbProviderFactories>
          <remove invariant="System.Data.SQLite.EF6" />
          <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
        <remove invariant="System.Data.SQLite" /><add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /></DbProviderFactories>
      </system.data>
• 创建数据实体类

  • public  class Room
        {
            public string ID { get; set; }
            public string RoomName { get; set; }
            public System.DateTime Time { get; set; }
            public int IsLook { get; set; }
            public bool Testing { get; set; }
        }

• 创建DBContext

  • public class DBModelEntities : DbContext
        {
            public DBModelEntities() : base("SQLiteConnection") { }       
            public DbSet<Room> Room { get; set; }
    
            protected override void OnModelCreating(DbModelBuilder modelBuilder)
            {
                base.OnModelCreating(modelBuilder);
    
                Assembly ass = Assembly.GetExecutingAssembly();
                modelBuilder.Configurations.AddFromAssembly(ass);
            }
        }

        class roomConfig : EntityTypeConfiguration<Room>
        {
            public roomConfig()
            {
                this.ToTable("Room");
            }
        }

• 参照 EF SQLite：使用Entity Framework的SQLite支持_笔记大全_设计学院