static void T5(LIBRARYEntities ctx)
{
//var r = ctx.Books.Where(q => q.Language_id);
//foreach (var i in r)
//{
// Console.WriteLine(i.Id + "|" + i.Language_id + "|" + i.Pages_count + "|" + i.Book_Name + "|" + i.Author_Id);
//}
}
static void T4(LIBRARYEntities ctx)
{
var r = from book in ctx.Books join author in ctx.Authors on book.Author_Id equals author.Id
foreach (var i in r)
{
Console.WriteLine(i.Id + "|" + i.Language_id + "|" + i.Pages_count + "|" + i.Book_Name + "|" + i.Author_Id);
}
}
static void T2(LIBRARYEntities ctx)
{
var r = ctx.Books.Where(q => q.Book_Name.StartsWith("A") || q.Book_Name.StartsWith("a"));
foreach (var i in r)
{
Console.WriteLine(i.Id + "|" + i.Language_id + "|" + i.Pages_count + "|" + i.Book_Name + "|" + i.Author_Id);
}
}
static void T3(LIBRARYEntities ctx)
{
var r = ctx.Books.Where(q => q.Book_Name.Length < 10);
foreach (var i in r)
{
Console.WriteLine(i.Id + "|" + i.Language_id + "|" + i.Pages_count + "|" + i.Book_Name + "|" + i.Author_Id);
}
}
static void Main(string[] args)
{
LIBRARYEntities ctx = new LIBRARYEntities();
//T1(ctx);
//T2(ctx);
//T3(ctx);
ctx.SaveChanges();
ctx.Dispose();
}