Hello

table 1: product

ProductId(PK)
Name
Type
Code

table 2: product detail

ProductDetailId(PK)
Detail
ProductId(FK)

now, the the ralation is 1:m between product and product detail, how to change it to 1:1 relation?

and now i want to get content from two table. code as below:

ProductEntity entity = new ProductEntity(productId);

//get details
ProductDetailEntity entityDetail = entity.CsbProductDetail[0];

above code will generate two sqls, how to do it in ONE sql?

any ideas will be appreciated. Thanks in advance.

For 1:1 relation, do the following.

table 2: product detail

ProductId(PK)(FK)
Detail

Then you can use the designer to make this an Inheritance Relation. And so:

ProductDetailEntity entityDetail = new ProductDetailEntity(productId);

Would fetch from both tables.

Or define a unique constraint on the ProductId fk field in ProductDetail.

Hello

great replies many thanks for both of your help.

ProductId(PK)(FK)
Detail

Using above format without implementing inheritance and using Detail as property of Product i am getting below error while saving Detail:

System.ArgumentNullException was caught Message=fieldsPersistenceInfo can't be null. Parameter name: fieldsPersistenceInfo Source=SD.LLBLGen.Pro.ORMSupportClasses.NET20 ParamName=fieldsPersistenceInfo StackTrace: at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateInsertDQ(IEntityFieldCore[] fields, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.CreateInsertDQ(IEntity2 entityToSave, IFieldPersistenceInfo[] persistenceInfoObjects) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.CreateQueryForEntityToSave(Boolean insertActions, EntityBase2 entityToSave, IPredicateExpression updateRestriction, InheritanceHierarchyType typeOfHierarchy, IFieldPersistenceInfo[] persistenceInfoObjects) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.PersistQueue(List`1 queueToPersist, Boolean insertActions, Int32& totalAmountSaved) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, IPredicateExpression updateRestriction, Boolean recurse) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, Boolean recurse)

I am using SD.LLBLGen.Pro.DQE.SqlServer.NET20.dll v2.6.08.1114 SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll v2.6.9.327

Is it not supported or is it a bug?

i have not tried it. maybe you should add another Primary Key.

morbia wrote:

ProductId(PK)(FK)
Detail

Please post more info about your entities/tables and inheritance.