public static void Artist()
{
using (var db = new ShirenEntities())
{
var artist = new Artist {
Name = "钱钟书"
};
var album1 = new Album {
Name = "围城"
};
var album2 = new Album {
Name = "我和那女孩"
};
artist.Albums.Add(album1);
artist.Albums.Add(album2);
var album = new Album {
Name = "梦里花落知多少"
};
var artist1 = new Artist {
Name = "郭敬明"
};
var artist2 = new Artist {
Name = "三毛"
};
album.Artists.Add(artist1);
album1.Artists.Add(artist2);
db.Artist.Add(artist);
db.Album.Add(album);
db.SaveChanges();
}
using (var db = new ShirenEntities())
{
var artist = db.Artist.FirstOrDefault();
var album = db.Album.FirstOrDefault();
if (artist == null)
{
return;
}
Console.WriteLine($"我是作者{artist.Name}，我的作品有：");
foreach (var item in artist.Albums)
{
Console.WriteLine("\t" + item.Name);
}
if (album == null)
{
return;
}
Console.WriteLine($"作品《{album.Name}》的作者是：");
foreach (var item in album.Artists)
{
Console.WriteLine("\t" + item.Name);
}
}
}
public static void Poem()
{
using (var db = new ShirenEntities())
{
var poem = new Poem {
Name = "赠汪伦"
};
var poet = new Poet {
Name = "李白"
};
var meter = new Meter {
TypeName = "赠友"
};
poem.Poet = poet;
poem.Meter = meter;
db.Poem.Add(poem);
poem = new Poem
{
Name = "登黄鹤楼",
Poet = poet,
Meter = meter
};
db.Poem.Add(poem);
poet = new Poet {
Name = "杜甫"
};
meter = new Meter {
TypeName = "抒情"
};
poem = new Poem
{
Name = "大漠孤烟直",
Poet = poet,
Meter = meter
};
db.Poem.Add(poem);
db.SaveChanges();
}
using (var db = new ShirenEntities())
{
var poems = db.Poem.ToList();
poems.ForEach(a => Console.WriteLine($"诗名：{a.Name}，诗人：{a.Poet.Name}，类型：{a.Meter.TypeName}"));
}
}
public static void Order()
{
using (var db = new ShirenEntities())
{
var order = new Order {
Customer = "孙小双", Time = DateTime.Now
};
var item1 = new Item {
Price = 28, Name = "苹果"
};
var item2 = new Item {
Price = 39, Name = "猕猴桃"
};
order.OrderItems.Add(new OrderItem {
Count = 2, Item = item1
});
order.OrderItems.Add(new OrderItem {
Count = 5, Item = item2
});
db.Order.Add(order);
db.SaveChanges();
}
using (var db = new ShirenEntities())
{
var order = db.Order.FirstOrDefault();
if (order == null)
{
return;
}
Console.WriteLine($"客户{order.Customer}在{order.Time:yyyy-MM-dd HH:mm:ss}下单：");
Console.WriteLine($"\t商品\t总数\t单价");
foreach (var item in order.OrderItems)
{
Console.WriteLine($"\t{item.Item.Name}\t{item.Count}\t{item.Item.Price:C}");
}
}
}
