public void Nested_Updates_And_Suspending_Constrains() { DB.Prepare(); DB.Link.Raw("ALTER TABLE Countries NOCHECK CONSTRAINT ALL").Execute(); DB.Link.Raw("ALTER TABLE Employees NOCHECK CONSTRAINT ALL").Execute(); var cmdCtry = DB.Link .Update(x => x.Countries) .Where(x => x.Id == "es") .Columns( x => x.Id = "es#"); ConsoleEx.WriteLine("\n> Command: {0}", cmdCtry); foreach (DataDB.Country ctry in cmdCtry.ConvertBy(recCtry => { ConsoleEx.WriteLine("\n\t- Country: {0}", recCtry); dynamic dinCtry = recCtry; DataDB.Country objCtry = new DataDB.Country(); objCtry.Id = dinCtry.Id; objCtry.Name = dinCtry.Name; objCtry.RegionId = dinCtry.RegionId; var cmdEmp = DB.Link .Update(x => x.Employees) .Where(x => x.CountryId == "es") .Columns( x => x.CountryId = "es#"); ConsoleEx.WriteLine("\n\t> Command: {0}", cmdEmp); foreach (DataDB.Employee emp in cmdEmp.ConvertBy(recEmp => { ConsoleEx.WriteLine("\n\t\t- Employee: {0}", recEmp); dynamic dinEmp = recEmp; DataDB.Employee objEmp = new DataDB.Employee(); objEmp.Id = dinEmp.Id; objEmp.BirthDate = dinEmp.BirthDate; objEmp.FirstName = dinEmp.FirstName; objEmp.LastName = dinEmp.LastName; objEmp.ManagerId = dinEmp.ManagerId; objEmp.CountryId = dinEmp.CountryId; return(objEmp); })) { ; } return(objCtry); })) { ; } DB.Link.Raw("ALTER TABLE Countries CHECK CONSTRAINT ALL").Execute(); DB.Link.Raw("ALTER TABLE Employees CHECK CONSTRAINT ALL").Execute(); DB.IsPrepared = false; }
public void Query_With_Complex_And_Nested_Conversion() { DB.Prepare(); var cmdCtry = DB.Link.From(x => x.Countries.As(x.Ctry)); ConsoleEx.WriteLine("\n> Command: {0}", cmdCtry); foreach (DataDB.Country ctry in cmdCtry.ConvertBy(recCtry => { ConsoleEx.WriteLine("\n- Country: {0}", recCtry); dynamic dinCtry = recCtry; DataDB.Country objCtry = new DataDB.Country(); objCtry.Id = dinCtry.Id; objCtry.Name = dinCtry.Name; objCtry.RegionId = dinCtry.RegionId; var cmdEmp = DB.Link.From(x => x.Employees).Where(x => x.CountryId == objCtry.Id); ConsoleEx.WriteLine("\n\t> SubCommand: {0}", cmdEmp); foreach (DataDB.Employee emp in cmdEmp.ConvertBy(recEmp => { ConsoleEx.WriteLine("\n\t\t- Employee: {0}", recEmp); dynamic dinEmp = recEmp; DataDB.Employee objEmp = new DataDB.Employee(); objEmp.Id = dinEmp.Id; objEmp.BirthDate = dinEmp.BirthDate; objEmp.FirstName = dinEmp.FirstName; objEmp.LastName = dinEmp.LastName; objEmp.ManagerId = dinEmp.ManagerId; objEmp.CountryId = dinEmp.CountryId; return(objEmp); })) { ; } return(objCtry); })) { ; } }
public void Query_With_Complex_And_Nested_Conversion() { DB.Prepare(); var cmdCtry = DB.Link.From(x => x.Countries.As(x.Ctry)); ConsoleEx.WriteLine("\n> Command: {0}", cmdCtry); foreach (DataDB.Country ctry in cmdCtry.ConvertBy(recCtry => { ConsoleEx.WriteLine("\n- Country: {0}", recCtry); dynamic dinCtry = recCtry; DataDB.Country objCtry = new DataDB.Country(); objCtry.Id = dinCtry.Id; objCtry.Name = dinCtry.Name; objCtry.RegionId = dinCtry.RegionId; var cmdEmp = DB.Link.From(x => x.Employees).Where(x => x.CountryId == objCtry.Id); ConsoleEx.WriteLine("\n\t> SubCommand: {0}", cmdEmp); foreach (DataDB.Employee emp in cmdEmp.ConvertBy(recEmp => { ConsoleEx.WriteLine("\n\t\t- Employee: {0}", recEmp); dynamic dinEmp = recEmp; DataDB.Employee objEmp = new DataDB.Employee(); objEmp.Id = dinEmp.Id; objEmp.BirthDate = dinEmp.BirthDate; objEmp.FirstName = dinEmp.FirstName; objEmp.LastName = dinEmp.LastName; objEmp.ManagerId = dinEmp.ManagerId; objEmp.CountryId = dinEmp.CountryId; return objEmp; })) ; return objCtry; })) ; }
public void Nested_Updates_And_Suspending_Constrains() { DB.Prepare(); DB.Link.Raw("ALTER TABLE Countries NOCHECK CONSTRAINT ALL").Execute(); DB.Link.Raw("ALTER TABLE Employees NOCHECK CONSTRAINT ALL").Execute(); var cmdCtry = DB.Link .Update(x => x.Countries) .Where(x => x.Id == "es") .Columns( x => x.Id = "es#"); ConsoleEx.WriteLine("\n> Command: {0}", cmdCtry); foreach (DataDB.Country ctry in cmdCtry.ConvertBy(recCtry => { ConsoleEx.WriteLine("\n\t- Country: {0}", recCtry); dynamic dinCtry = recCtry; DataDB.Country objCtry = new DataDB.Country(); objCtry.Id = dinCtry.Id; objCtry.Name = dinCtry.Name; objCtry.RegionId = dinCtry.RegionId; var cmdEmp = DB.Link .Update(x => x.Employees) .Where(x => x.CountryId == "es") .Columns( x => x.CountryId = "es#"); ConsoleEx.WriteLine("\n\t> Command: {0}", cmdEmp); foreach (DataDB.Employee emp in cmdEmp.ConvertBy(recEmp => { ConsoleEx.WriteLine("\n\t\t- Employee: {0}", recEmp); dynamic dinEmp = recEmp; DataDB.Employee objEmp = new DataDB.Employee(); objEmp.Id = dinEmp.Id; objEmp.BirthDate = dinEmp.BirthDate; objEmp.FirstName = dinEmp.FirstName; objEmp.LastName = dinEmp.LastName; objEmp.ManagerId = dinEmp.ManagerId; objEmp.CountryId = dinEmp.CountryId; return objEmp; })) ; return objCtry; })) ; DB.Link.Raw("ALTER TABLE Countries CHECK CONSTRAINT ALL").Execute(); DB.Link.Raw("ALTER TABLE Employees CHECK CONSTRAINT ALL").Execute(); DB.IsPrepared = false; }