Hi,
i did the test as follows:
[Test]
public void EmployeeMapping()
{
var factory =
MySQLiteSessionFactory.CreateSessionFactory();
var employee = new
ProjectTracker.Domain.Employees.Employee() {
CreatedBy ="me",
CreatedAt = DateTime.Today,
EmployeeId = "10"
};
var address1 = new EmployeeAddress();
address1.CreatedBy ="me";
address1.CreatedAt = DateTime.Today;
address1.Address = new Address() {
ZipCode = "88161"
};
address1.Employee = employee;
var addressList = new
System.Collections.Generic.List<EmployeeAddress>();
addressList.Add(address1);
// employee.Addresses = addressList;
new
PersistenceSpecification<ProjectTracker.Domain.Employees.Employee>(factory.OpenSession())
/*
.CheckProperty(c => c.CreatedAt, DateTime.Today)
.CheckProperty(c => c.UpdatedAt, DateTime.Today)
.CheckProperty(c => c.CreatedBy,
WindowsIdentity.GetCurrent().Name)
.CheckProperty(c => c.EmployeeId, "10")
.CheckProperty(c => c.HoursPerWeek,
Convert.ToDouble(40.5))
.CheckProperty(c => c.HireDate, DateTime.Today)
*/
.CheckProperty(c => c.CreatedAt,
employee.CreatedAt)
.CheckProperty(c => c.UpdatedAt, DateTime.Today)
.CheckProperty(c => c.CreatedBy,
employee.CreatedBy)
.CheckProperty(c => c.EmployeeId,
employee.EmployeeId)
.CheckProperty(c => c.HoursPerWeek,
Convert.ToDouble(40.5))
.CheckProperty(c => c.HireDate, DateTime.Today)
.CheckList(c =>
c.Addresses,employee.Addresses)
.VerifyTheMappings();
}
NHibernate: INSERT INTO Employees (Version, CreatedAt, CreatedBy,
UpdatedAt, UpdatedBy, EmployeeId, Firstname, Lastname, HoursPerWeek,
BirthDate, HireDate, SickDays, VacationDays, Salutation_id, Id) VALUES
(@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12,
@p13, @p14);@p0 = 1 [Type: Int32 (0)], @p1 = 25.04.2013 08:31:00
[Type: DateTime (0)], @p2 = 'FORSTMEIER\Peter Forstmeier' [Type:
String (0)], @p3 = NULL [Type: DateTime (0)], @p4 = NULL [Type: String
(0)], @p5 = '10' [Type: String (0)], @p6 = NULL [Type: String (0)],
@p7 = NULL [Type: String (0)], @p8 = 0 [Type: Double (0)], @p9 = NULL
[Type: DateTime (0)], @p10 = NULL [Type: DateTime (0)], @p11 = 0
[Type: Int32 (0)], @p12 = 0 [Type: Int32 (0)], @p13 = NULL [Type:
Int32 (0)], @p14 = e05d2d11-d224-4f40-8885-a1ab008c5aae [Type: Guid
(0)]
NHibernate: INSERT INTO InheritedAddresses (ZipCode, Town,
AddressLine1, Country, Id) VALUES (@p0, @p1, @p2, @p3, @p4);@p0 =
'88161' [Type: String (0)], @p1 = NULL [Type: String (0)], @p2 = NULL
[Type: String (0)], @p3 = NULL [Type: String (0)], @p4 =
392b2313-115b-49d0-aeb1-a1ab008c5ab2 [Type: Guid (0)]
NHibernate: INSERT INTO EmployeeAddresses (Version, CreatedAt,
CreatedBy, UpdatedAt, UpdatedBy, AddressType, EmployeeId, AddressId,
Id) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8);@p0 = 1
[Type: Int32 (0)], @p1 = 25.04.2013 00:00:00 [Type: DateTime (0)], @p2
= 'me' [Type: String (0)], @p3 = 25.04.2013 08:31:00 [Type: DateTime
(0)], @p4 = 'FORSTMEIER\Peter Forstmeier' [Type: String (0)], @p5 =
'Home' [Type: String (0)], @p6 = e05d2d11-d224-4f40-8885-a1ab008c5aae
[Type: Guid (0)], @p7 = 392b2313-115b-49d0-aeb1-a1ab008c5ab2 [Type:
Guid (0)], @p8 = 0832ed14-5d69-4521-8e8d-a1ab008c5aa9 [Type: Guid (0)]
) Test Error :
ProjectTracker.Test.Mappings.EmployeeMappingsFixture.EmployeeMapping
NHibernate.Exceptions.GenericADOException : could not insert:
[ProjectTracker.Domain.Employees.EmployeeAddress#0832ed14-5d69-4521-8e8d-
a1ab008c5aa9][SQL: INSERT INTO EmployeeAddresses (Version, CreatedAt,
CreatedBy, UpdatedAt, UpdatedBy, AddressType, EmployeeId, AddressId,
Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
----> System.Data.SQLite.SQLiteException : SQLite error
no such table: EmployeeAddresses
I try the commented part as well
Peter
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
