Hi List,
i have no idea what's wrong with this mapping.
public EmployeeMapping()
{
........
HasMany(x => x.Addresses).Not.LazyLoad();
}
public class BaseAdressMapping : ClassMap<Address>
{
public BaseAdressMapping()
{
Table("InheritedAddresses");
Id(x =>
x.Id).GeneratedBy.GuidComb().UnsavedValue("00000000-0000-0000-0000-000000000000");
Map(x =>
x.ZipCode).Length(DefaultFieldDescription.DefaultIdLength);
Map(x =>
x.Town).Length(DefaultFieldDescription.DefaultStringColumnLength);
Map(x =>
x.AddressLine1).Length(DefaultFieldDescription.DefaultStringColumnLength);
Map(x =>
x.Country).Length(DefaultFieldDescription.DefaultStringColumnLength);
}
}
[Test]
public void Employee()
{
var factory = MySQLiteSessionFactory.CreateSessionFactory();
var adr1 = new Address() {
ZipCode = "aa"
};
var adr2 = new Address() {
ZipCode = "aa"
};
var list = new
System.Collections.Generic.List<Address>();
list.Add(adr1);
list.Add(adr2);
PersistenceSpecification<ProjectTracker.Domain.Employees.Employee>(factory.OpenSession())
.CheckProperty(c => c.CreatedAt, DateTime.Today)
.CheckList(c => c.Addresses,list)
VerifyTheMappings();
}
The table's are created:
create table InheritedAddresses (
Id UNIQUEIDENTIFIER not null,
ZipCode TEXT,
Town TEXT,
AddressLine1 TEXT,
Country TEXT,
Employee_id UNIQUEIDENTIFIER,
primary key (Id),
constraint FK1452CB75BF9AA6F3 foreign key (Employee_id)
references Employees
)
NHibernate.Exceptions.GenericADOException : could not insert
collection:
[ProjectTracker.Domain.Employees.Employee.Addresses#b0fd8b90-7a2d-4283-
abf9-a1a5011ae0d5][SQL: UPDATE InheritedAddresses SET Employee_id =
@p0 WHERE Id = @p1]
----> System.Data.SQLite.SQLiteException : SQLite error
no such column: Employee_id
Any idea's
Thanks
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.
