使用entityframework操作sqlite数据库

转载

mb5fe3290a9b4fe 2016-09-22 14:56:00

文章标签 sqlite bundle ide html 插入数据 文章分类 代码人生

首先要安装好，所需要的类库，通过NuGet来处理

http://stackoverflow.com/questions/28507904/vs-2015-sqlite-data-provider

安装这个http://system.data.sqlite.org/downloads

下载最新版 sqlite-netFx46-setup-bundle-x86-2015-1.0.103.0.exe

注意：在安装这个bundle的时候，必须勾选全部

使用entityframework操作sqlite数据库_sqlite

https://erazerbrecht.wordpress.com/2015/06/11/sqlite-entityframework-6-tutorial/

如何插入数据，数据存在就更新

http://stackoverflow.com/questions/6966207/entityframework-insert-if-not-exist-otherwise-update

void Method(object sender, DocumentLoadedEvent e)
{
    var data = e.ParsedData as Country[];
    using(var db = new DataContractEntities)
    {
        var names = data.Select(c => c.Name);
        var countriesInDb = db.Countries
            .Where(c => names.Contains(c.Name))
            .ToList(); // single DB query
        foreach(var country in data)
        {
            var countryInDb = countriesInDb
                .SingleOrDefault(c => c.Name == country.Name); // runs in memory
            if (countryInDb != null)
                db.Countries.ApplyCurrentValues(country);
            else
                db.Countries.AddObject(country);
        }
        db.SaveChanges();
     }
}