You didn't include the mapping for the Employee, but I'd say the
association to InheritedAddresses needs to be inverse, because it's
the InheritedAddresses table that holds the foreign key to Employee.
RP
On Friday, April 19, 2013 4:19:11 PM UTC+1, Peter Forstmeier wrote:
>
> 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.
