public static void show()
{
context ct = new context();
var authors = ct.authors;
Console.WriteLine("Author details");
foreach (var p in authors)
{
Console.WriteLine("{0}\t{1}\t{2}", p.aid, p.name, p.address);
}
var books = ct.books;
Console.WriteLine("Book details");
foreach (var p in books)
{
Console.WriteLine("{0}\t{1}\t{2}", p.bid, p.title, p.price);
}
var details = ct.details;
Console.WriteLine(" details");
Console.WriteLine("{0,-8}{1,-14}{2,-8}{3,-14}{4,10}{5,8}{6,15}", "dtid", "bid", "name", "price", "aid", "name", "address");
foreach (var p in details)
{
Console.WriteLine("{0,-8}{1,-14}{2,-8}{3,-14}{4,10}{5,8}{6,15}", p.id, p.bid, p.book.title, p.book.price, p.aid, p.author.name, p.author.address);
}
}
public static void InsertInitialData()
{
context t = new context();
var authors = new List <Author>
{
new Author {
name = "Ravinder", address = "Punjab"
},
new Author {
name = "Sudeep", address = "Mumbai"
},
new Author {
name = "PreetyShenoy", address = "Delhi"
},
new Author {
name = "Chetan", address = "Chennai"
},
};
authors.ForEach(s => t.authors.Add(s));
t.SaveChanges();
var books = new List <Book>
{
new Book {
title = "Dreams", price = 150
},
new Book {
title = "Mahabharat", price = 170
},
new Book {
title = "Ramayana", price = 100
},
new Book {
title = "Gita", price = 200
},
};
books.ForEach(p => t.books.Add(p));
t.SaveChanges();
var detail = new List <Detail>
{
new Detail {
aid = 1, bid = 2
},
new Detail {
aid = 2, bid = 3
},
new Detail {
aid = 3, bid = 2
},
new Detail {
aid = 3, bid = 3
},
};
detail.ForEach(d => t.details.Add(d));
t.SaveChanges();
}