SQLite数据库ADO.NET实体数据模型使用示例

using System;
using System.Linq;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            using(var db = new mainEntities())
            {
                //Insert
                db.UserTB.Add(new UserTB() { Name = "张三", Age = 20 });
                db.UserTB.Add(new UserTB() { Name = "李四", Age = 30 });
                db.SaveChanges();

                //Update
                var user1 = db.UserTB.FirstOrDefault();
                user1.Name += "new";
                db.SaveChanges();

                //Delete
                var user2 = db.UserTB.OrderByDescending(item => item.Id).FirstOrDefault(); //不识别方法LastOrDefault
                db.UserTB.Remove(user2);
                db.SaveChanges();

                //Select
                var data = db.UserTB.ToList();
                foreach(var item in data)
                {
                    Console.WriteLine("{0},{1},{2}", item.Id, item.Name, item.Age);
                }
            }

            Console.ReadLine();
        }
    }
}