Composite Key mapping not hydrating child tables

[andreyciocan]

Hello!

I have some custom mappings done with nhibernate. If my relation is based on simple key, everything works fine. But if my relation is based on composite key, the object children are not hydrated although the sql query generated is correct.

Here is my mapping code:

if (isVersioning)
{
//coposed key not hydrating
	classMapper.Set(setProperty,
		set =>
		{
			set.Table($"{table.DBName}{baseReferenceField.DBName}");
			set.Schema("Versions");
			set.Key(k => k.Columns(c => c.Name(table.DBName), c => c.Name("Version")));
			set.Cascade(Cascade.None);
		},
		elem =>
		{
			elem.ManyToMany(e =>
			{
				e.Column(baseReferenceField.DBName);
				e.Class(setProperty.PropertyType.GetGenericArguments()[0]);
			});
		});
}
else
{
//works fine
	classMapper.Set(setProperty,
		 set =>
		 {
			 set.Table($"{table.DBName}{baseReferenceField.DBName}");
			 set.Schema("Data");
			 set.Key(k => k.Column(table.DBName));
			 set.Cascade(Cascade.None);
		 },
		 elem =>
		 {
			 elem.ManyToMany(e =>
			 {
				 e.Column(baseReferenceField.DBName);
				 e.Class(setProperty.PropertyType.GetGenericArguments()[0]);
			 });
		 });
}

[bahusoid]

the object children are not hydrated although the sql query generated is correct

I don't understand what it means. Please provide at least code snippet when it happens (does it happen on session.Get or it needs to be a query?). Does it throw any exception (if so provide full stacktrace)?

[andreyciocan]

Hello!

There is no exception. The query is generated just fine and runs on sql server (as seen from profiler), but my resulting object (from mapping) does not contain any data (again, only when I'm using a composite key for foreign constraint)