- 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>
- <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>
- <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>
- <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支持_笔记大全_设计学院
EF SQLite:使用Entity Framework的SQLite支持
于 2023-11-13 16:59:51 首次发布