partial void DeleteEmployeeTerritory(EmployeeTerritory instance);
public void LinqToSqlInsert03()
{
Northwind db = CreateDB();
var ds = new DataLoadOptions();
ds.LoadWith<Employee>(p => p.EmployeeTerritories);
ds.LoadWith<EmployeeTerritory>(p => p.Territory);
db.LoadOptions = ds;
var q = from e in db.Employees where e.FirstName == "Nancy" select e;
if (db.Employees.Any(e => e.FirstName == "Test Kira" && e.LastName == "Test Smith"))
Assert.Ignore();
var newEmployee = new Employee { FirstName = "Test Kira", LastName = "Test Smith" };
var newTerritory = new Territory
{
TerritoryID = "12345",
TerritoryDescription = "Test Anytown",
Region = db.Regions.First()
};
var newEmployeeTerritory = new EmployeeTerritory { Employee = newEmployee, Territory = newTerritory };
db.Employees.InsertOnSubmit(newEmployee);
db.Territories.InsertOnSubmit(newTerritory);
db.EmployeeTerritories.InsertOnSubmit(newEmployeeTerritory);
db.SubmitChanges();
// cleanup
db.EmployeeTerritories.DeleteOnSubmit(newEmployeeTerritory);
db.Territories.DeleteOnSubmit(newTerritory);
db.Employees.DeleteOnSubmit(newEmployee);
db.SubmitChanges();
}
partial void InsertEmployeeTerritory(EmployeeTerritory instance);
partial void UpdateEmployeeTerritory(EmployeeTerritory instance);
private void attach_EmployeeTerritories(EmployeeTerritory entity)
{
this.SendPropertyChanging();
entity.Employee = this;
}
private void detach_EmployeeTerritories(EmployeeTerritory entity)
{
this.SendPropertyChanging();
entity.Territory = null;
}
public void LinqToSqlInsert03() {
Northwind db2 = new Northwind(connString);
DataLoadOptions ds = new DataLoadOptions();
ds.LoadWith<nwind.Employee>(p => p.EmployeeTerritories);
ds.LoadWith<nwind.EmployeeTerritory>(p => p.Territory);
db2.LoadOptions = ds;
var q = (
from e in db.Employees
where e.FirstName == "Nancy"
select e);
Console.WriteLine("*** BEFORE ***");
ObjectDumper.Write(q, 1);
Console.WriteLine();
Console.WriteLine("*** INSERT ***");
var newEmployee = new Employee { FirstName = "Kira",
LastName = "Smith"
};
var newTerritory = new Territory { TerritoryID = "12345",
TerritoryDescription = "Anytown",
Region = db.Regions.First()
};
var newEmployeeTerritory = new EmployeeTerritory { Employee = newEmployee,
Territory = newTerritory
};
db.Employees.InsertOnSubmit(newEmployee);
db.Territories.InsertOnSubmit(newTerritory);
db.EmployeeTerritories.InsertOnSubmit(newEmployeeTerritory);
db.SubmitChanges();
Console.WriteLine();
Console.WriteLine("*** AFTER ***");
ObjectDumper.Write(q, 2);
Cleanup66(); // Restore previous database state
}
public void EmployeeTerritories_Detach(EmployeeTerritory entity)
{
entity.Employee = null;
}
public void EmployeeTerritories_Attach(EmployeeTerritory entity)
{
entity.Employee = this;
}
private void EmployeeTerritories_Attach(EmployeeTerritory entity)
{
this.SendPropertyChanging();
entity.Territory = this;
}
private void EmployeeTerritories_Detach(EmployeeTerritory entity)
{
this.SendPropertyChanging();
entity.Employee = null;
}
