public void Commit_Validation01() { String guid; using (IMobeelizerTransaction db = Mobeelizer.GetDatabase().BeginTransaction()) { var departments = db.GetModelSet<Department>(); Department department = new Department(); department.Name = "Dep1"; department.InternalNumber = 333; departments.InsertOnSubmit(department); db.SubmitChanges(); guid = department.Guid; } using (IMobeelizerTransaction db = Mobeelizer.GetDatabase().BeginTransaction()) { var employees = db.GetModelSet<Employee>(); Employee employee = new Employee(); employee.Name = "NameNameNameNameNameNameNameNameNameNameName"; employee.Surname = "Surname"; employee.Position = "Position"; employee.Department = guid; employees.InsertOnSubmit(employee); String exceptionMessage = string.Empty; bool thrown = false; try { db.SubmitChanges(); } catch (ArgumentException e) { thrown = true; exceptionMessage = e.Message; } Assert.IsTrue(thrown); Assert.IsTrue(exceptionMessage.Contains("Name")); } }
public void Querys() { String justAddEntityGuid = string.Empty; using (IMobeelizerTransaction db = Mobeelizer.GetDatabase().BeginTransaction()) { var departmentTable = db.GetModelSet<Department>(); Department de = new Department(); de.InternalNumber = 1; de.Name = "ddd"; departmentTable.InsertOnSubmit(de); db.SubmitChanges(); justAddEntityGuid = de.Guid; } using (IMobeelizerTransaction transaction = Mobeelizer.GetDatabase().BeginTransaction()) { var employees = transaction.GetModelSet<Employee>(); Employee employee = new Employee() { Department = justAddEntityGuid, Name = "name", Position = "position", Surname = "surname", Salary = 13 }; employees.InsertOnSubmit(employee); transaction.SubmitChanges(); } using (IMobeelizerTransaction transaction = Mobeelizer.GetDatabase().BeginTransaction()) { var employees = transaction.GetModelSet<Employee>(); var departments = transaction.GetModelSet<Department>(); var query = from e in employees join d in departments on e.Department equals d.Guid select new { eName = e.Name, dName = d.Name }; int found = 0; foreach (var result in query) { ++found; } Assert.IsTrue(found > 0); } }