估计这问题你们也不会,关于EF 4.1 Code First ; 使用 SqlLite 或者 MySQL 等非SQLServer的数据库
以前那些 Database First , Modal First 都不合口味,可是这次 Code First 出现后,就觉得太棒了!
就是我一直梦想的动态实现 类<--->数据库 互相转换。
在一些大运算量的地方,类---->内存数据库, 计算方便又快速。
但是,似乎搞了半天也没能学会用 第三方数据库
class Program { static void Main(string[] args) { NerdDinners nerdDinners = new NerdDinners(); var dinner = new Dinner { Title = "Par at Scott's House", EventDate = DateTime.Parse("12/31/2013"), Address = "Building 40", HostedBy = "scottgu@microsoft.com" }; nerdDinners.Dinners.Add(dinner); nerdDinners.SaveChanges(); var dinners = from d in nerdDinners.Dinners select d; foreach (var item in dinners) { Console.WriteLine(item.ToString()); } } } public class Dinner { public int DinnerID { get; set; } public string Title { get; set; } public DateTime EventDate { get; set; } public string Address { get; set; } public string HostedBy { get; set; } public virtual ICollection<RSVP> RSVPs { get; set; } } public class RSVP { public int RsvpID { get; set; } public int DinnerID { get; set; } public string AttendeeEmail { get; set; } public virtual Dinner Dinner { get; set; } } public class NerdDinners : DbContext { public NerdDinners(IDbConnection dbconn) :base("abcdefg") { } public DbSet<Dinner> Dinners { get; set; } public DbSet<RSVP> RSVPs { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { //modelBuilder.Configurations; base.OnModelCreating(modelBuilder); } }