public static void Delete()
{
using (EntityModelContext context = new EntityModelContext())
{
Employee emp = context.Employees.Include(p => p.EmployeeDetail).Where(p => p.Id == 5).FirstOrDefault();
context.Entry <Employee>(emp).State = EntityState.Deleted;
context.SaveChanges();
}
Console.ReadLine();
}
public static void Update()
{
using (EntityModelContext context = new EntityModelContext())
{
Employee emp = context.Employees.Where(p => p.Id == 5).FirstOrDefault();
emp.Name = "Meera";
context.Entry(emp).Property("CreatedDate").CurrentValue = DateTime.Now;
context.SaveChanges();
}
Console.ReadLine();
}
public static void Update()
{
using (EntityModelContext context = new EntityModelContext())
{
Employee emp = context.Employees.Include(p => p.EmployeeDetail).Where(p => p.Id == 5).FirstOrDefault();
emp.Name = "Meera";
emp.EmployeeDetail.EmailAddress = "*****@*****.**";
context.SaveChanges();
}
Console.ReadLine();
}
public static void Select()
{
using (EntityModelContext context = new EntityModelContext())
{
Console.WriteLine("------------- Employee Entity -------------");
var data1 = context.Employees
.OrderBy(b => EF.Property <DateTime>(b, "CreatedDate")).ToList();
Console.ReadLine();
Console.Clear();
}
}
public static void UsingContextLevelNoTrack()
{
using (EntityModelContext context = new EntityModelContext())
{
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var data = context.Employees.ToList();
foreach (var d in data)
{
Console.WriteLine("{0}\t{1}", d.Id, d.Name);
}
Console.ReadLine();
}
}
public static void Insert()
{
using (EntityModelContext context = new EntityModelContext())
{
Employee emp = new Employee
{
Id = 5,
Name = "Vishal",
};
context.Entry(emp).Property("CreatedDate").CurrentValue = DateTime.Now;
context.Add(emp);
context.SaveChanges();
}
Console.ReadLine();
Console.Clear();
}
public static void Select1()
{
using (EntityModelContext context = new EntityModelContext())
{
Console.WriteLine("------------- Employee Entity -------------");
var data1 = (from p in context.Employees
select new
{
Id = p.Id,
Name = p.Name,
CreateDate = EF.Property <DateTime>(p, "CreatedDate")
}).ToList();
Console.ReadLine();
Console.Clear();
}
}
public static void OtherExample()
{
using (EntityModelContext context = new EntityModelContext())
{
//Automatically no track applied
var data1 = context.Employees.Select(emp => new
{
id = emp.Id,
name = emp.Name,
}).ToList();
//Entity framework track Employee entity type
var data2 = context.Employees.Select(emp => new
{
id = emp.Id,
Employee = emp
}).ToList();
}
}
public static void Insert()
{
using (EntityModelContext context = new EntityModelContext())
{
Employee emp = new Employee
{
Id = 5,
Name = "Vishal",
IsDeleted = false,
EmployeeDetail = new EmployeeDetail {
EmailAddress = "*****@*****.**", MobileNumber = "895648552"
}
};
context.Add(emp);
context.SaveChanges();
}
Console.ReadLine();
Console.Clear();
}
static void Main(string[] args)
{
using (EntityModelContext context = new EntityModelContext())
{
Console.WriteLine("---------------With Global Query Filters---------------");
var data = context.Employees.ToList();
foreach (var d in data)
{
Console.WriteLine("{0}\t{1}", d.Id, d.Name);
}
Console.WriteLine("---------------Ignore Global Query Filters---------------");
var data1 = context.Employees
.IgnoreQueryFilters().ToList();
foreach (var d in data1)
{
Console.WriteLine("{0}\t{1}", d.Id, d.Name);
}
Console.ReadLine();
}
}
public static void UsingExtensionMethod()
{
using (EntityModelContext context = new EntityModelContext())
{
var data = context.Employees
.AsNoTracking().ToList();
foreach (var d in data)
{
Console.WriteLine("{0}\t{1}", d.Id, d.Name);
}
var data1 = context.Employees
.Where(p => p.Id > 2)
.AsNoTracking().ToList();
foreach (var d in data)
{
Console.WriteLine("{0}\t{1}", d.Id, d.Name);
}
Console.ReadLine();
}
}
public static void Select()
{
using (EntityModelContext context = new EntityModelContext())
{
Console.WriteLine("------------- Employee Entity -------------");
var data1 = context.Employees.ToList();
Console.ReadLine();
Console.Clear();
Console.WriteLine("------------- EmployeeDetail Entity -------------");
var data2 = context.EmployeeDetails.ToList();
Console.ReadLine();
Console.Clear();
Console.WriteLine("------------- Both Entities together -------------");
var data3 = context.Employees.Include(p => p.EmployeeDetail).ToList();
Console.ReadLine();
Console.Clear();
}
}
public MyDetailsController(EntityModelContext context)
{
_context = context;
}
