Exemplo n.º 1
0
        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}");
                }
            }
        }
Exemplo n.º 2
0
        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
        }