# SQLiteCodeFirst

**Repository Path**: zhxd19/sqlite-code-first

## Basic Information

- **Project Name**: SQLiteCodeFirst
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-06-25
- **Last Updated**: 2024-06-25

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SQLiteCodeFirst

1、Nuget 安装下面的包
	<package id="EntityFramework" version="6.5.1" targetFramework="net48" />
	<package id="SQLite.CodeFirst" version="1.7.0.36" targetFramework="net48" />
	<package id="Stub.System.Data.SQLite.Core.NetFramework" version="1.0.118.0" targetFramework="net48" />
	<package id="System.Data.SQLite" version="1.0.118.0" targetFramework="net48" />
	<package id="System.Data.SQLite.Core" version="1.0.118.0" targetFramework="net48" />
	<package id="System.Data.SQLite.EF6" version="1.0.118.0" targetFramework="net48" />
	<package id="System.Data.SQLite.EF6.Migrations" version="1.0.113" targetFramework="net48" />
	<package id="System.Data.SQLite.Linq" version="1.0.118.0" targetFramework="net48" />
    在配置文件中添加  
    <provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
2、在Model类库中建立DbContext：DbContext
	在该文件下添加如下代码
	  public static SQLiteConnection Connection()
        {
            
            SQLiteConnection conn = new SQLiteConnection();
            conn.ConnectionString = $@"Data Source={DbPath}"; 
            conn.Open();
            return conn;
        }
        public MyDbContext() : base(Connection(), false) { }  
3、 Enable-Migrations 后在生成的Migrations文件夹下面的Configuration.cs添加如下代码
	    public Configuration()
        {
            AutomaticMigrationsEnabled = false;
            //出现 下面错误No MigrationSqlGenerator found for provider 'System.Data.SQLite'. Use the SetSqlGenerator method in the target migrations configuration class to register additional SQL generators.
            //添加下面代码
            SetSqlGenerator("System.Data.SQLite", new SQLiteMigrationSqlGenerator());
        }
4、Add-Migration update-database
生成的数据库文件在Model文件夹下 问题没有解决！！！应该拷贝的EXE文件夹下