public static void Run() { using (var db = new EmployeeContext()) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); } using (var db = new EmployeeContext()) { db.Employees.Add(new Employee { Name = "John Doe" }); db.Employees.Add(new Employee { Name = "Jane Doe", EmploymentStarted = new DateTime(2000, 1, 1) }); db.SaveChanges(); foreach (var employee in db.Employees) { Console.WriteLine($"{employee.EmployeeId}: {employee.Name}, {employee.EmploymentStarted}"); } } using (var db = new EmployeeContext()) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); } using (var db = new EmployeeContext()) { db.Employees.Add(new Employee { EmployeeId = 100, Name = "John Doe" }); db.Employees.Add(new Employee { EmployeeId = 101, Name = "Jane Doe" }); db.Database.OpenConnection(); try { db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Employee ON"); db.SaveChanges(); db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Employee OFF"); } finally { db.Database.CloseConnection(); } foreach (var employee in db.Employees) { Console.WriteLine($"{employee.EmployeeId}: {employee.Name}"); } } }
public static async Task RunAsync() { await using (var context = new EmployeeContext()) { await context.Database.EnsureDeletedAsync(); await context.Database.EnsureCreatedAsync(); } #region EmploymentStarted await using (var context = new EmployeeContext()) { context.Employees.Add(new Employee { Name = "John Doe" }); context.Employees.Add(new Employee { Name = "Jane Doe", EmploymentStarted = new DateTime(2000, 1, 1) }); await context.SaveChangesAsync(); await foreach (var employee in context.Employees) { Console.WriteLine(employee.EmployeeId + ": " + employee.Name + ", " + employee.EmploymentStarted); } } #endregion await using (var context = new EmployeeContext()) { await context.Database.EnsureDeletedAsync(); await context.Database.EnsureCreatedAsync(); } #region EmployeeId await using (var context = new EmployeeContext()) { context.Employees.Add(new Employee { EmployeeId = 100, Name = "John Doe" }); context.Employees.Add(new Employee { EmployeeId = 101, Name = "Jane Doe" }); await context.Database.OpenConnectionAsync(); try { await context.Database.ExecuteSqlRawAsync("SET IDENTITY_INSERT dbo.Employees ON"); await context.SaveChangesAsync(); await context.Database.ExecuteSqlRawAsync("SET IDENTITY_INSERT dbo.Employees OFF"); } finally { await context.Database.CloseConnectionAsync(); } foreach (var employee in context.Employees) { Console.WriteLine(employee.EmployeeId + ": " + employee.Name); } } #endregion await using (var context = new EmployeeContext()) { await context.Database.EnsureDeletedAsync(); await context.Database.EnsureCreatedAsync(); await context.Database.ExecuteSqlRawAsync( await File.ReadAllTextAsync(@"ExplicitValuesGenerateProperties\employee_UPDATE.sql")); context.Employees.Add(new Employee { Name = "John Doe", Salary = 100 }); context.Employees.Add(new Employee { Name = "Jane Doe", Salary = 100 }); await context.SaveChangesAsync(); } #region LastPayRaise await using (var context = new EmployeeContext()) { var john = context.Employees.Single(e => e.Name == "John Doe"); john.Salary = 200; var jane = context.Employees.Single(e => e.Name == "Jane Doe"); jane.Salary = 200; jane.LastPayRaise = DateTime.Today.AddDays(-7); await context.SaveChangesAsync(); await foreach (var employee in context.Employees) { Console.WriteLine(employee.EmployeeId + ": " + employee.Name + ", " + employee.LastPayRaise); } } #endregion }