private static void case2()
{
HiTechDbContext db = new HiTechDbContext();
var data = db.Students.Select(s => new { n = s.Name, a = s.Age }).ToList();
foreach (var d in data)
{
Console.WriteLine("Name : " + d.n + " Age :" + d.a);
}
var data1 = db.Students.Where(s => s.Name.Contains("s")).ToList();
Console.WriteLine();
Console.WriteLine("Students whose Name contains S");
foreach (var d in data1)
{
Console.WriteLine("Name : " + d.Name + " Age :" + d.Age);
}
var data2 = db.Students.Where(s => s.Name.Equals("Akash")).ToList();
Console.WriteLine("Students whose Name contains S");
foreach (var d in data1)
{
Console.WriteLine("Name : " + d.Name + " Age :" + d.Age);
}
}
private static void case3()
{
HiTechDbContext db = new HiTechDbContext();
var data = db.Students.Where(s => s.Name.Contains("a"))
.Take(2)
.ToList();
foreach (var d in data)
{
Console.WriteLine("Name : " + d.Name + " Age :" + d.Age);
}
}
private static void case5()
{
HiTechDbContext db = new HiTechDbContext();
var data = db.Students.Where(s => s.Name.Contains("a"))
.Where(s => s.Age > 18)
.ToList()
.Select(s => new { n = s.Name.Split(' ')[0], a = s.Age })
.Take(2);
foreach (var d in data)
{
Console.WriteLine("Name : " + d.n + " Age :" + d.a);
}
}
private static void case1()
{
HiTechDbContext db = new HiTechDbContext();
Student s = new Student(Guid.NewGuid(), "Brijesh", 22, "Gandhidham");
Student s1 = new Student();
s1.ID = Guid.NewGuid();
s1.Name = "Akash";
s1.Age = 23;
s1.Location = "Ahmedabad";
db.Students.Add(s);
db.Students.Add(s1);
db.SaveChanges();
Console.WriteLine("Actions Performed");
}
