EF基础，从0开始：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity;
using ponentModel.DataAnnotations;
namespace CodeFirstNewDatabase
{
class Program
{
static void Main(string[] args)
{
using (var db = new BloggingContext())
{
Console.Write("Enter a name for a new Blog: ");
var name = Console.ReadLine();
var blog = new Blog { Name = name };
db.Blogs.Add(blog);
db.SaveChanges();
var query = from b in db.Blogs
orderby b.Name
select b;
Console.WriteLine("All blogs in the database:");
foreach (var item in query)
{
Console.WriteLine(item.Name);
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
}
public class Blog
{
public int BlogID { get; set; }
public string Name { get; set; }
public string Url { get; set; }
public virtual IList Posts { get; set; }
}
public class Post
{
public int PostID { get; set; }
public string Title { get; set; }
public string Content { get; set; }
public int BlogId { get; set; }
public virtual Blog Blog { get; set; }
}
public class User
{
[Key] // annotation: keyattribute
public string Username { get; set; }
public string Displayname { get; set; }
}
public class BloggingContext : DbContext
{
public DbSet Blogs { get; set; }
public DbSet Posts { get; set; }
public DbSet Users { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder) // fluent api: override onmodelcreating method
{
modelBuilder.Entity()
.Property(u => u.Displayname)
.HasColumnName("Display_name");
}
}
}
作者：incognito007 发表于-3-14 10:09:35 原文链接
阅读：49 评论：0 查看评论
