I am just getting around to converting a project from llbl 1.0 to 2.0. I made extensive use of the SelectOneWXXXXLogic method in the old classes. Is there an equivilant way to load a record based on a unique foriegn key?

You mean from LLBLGen 1.x dal generator to LLBLGen Pro ? The code is completely different. TO load an entity using a unique constraint, you have to use the proper methods to do so which differ in selfservicing or adapter. Which are you using?

I am using the Adapter configuration. Here is the code I use in DAL 1.0

Dim sr As New ld_masterLLBL.clsLd_ins_submission sr.iResident_id = (SqlTypes.SqlInt32.Parse(resident_id)) sr.SelectOneWresident_idLogic()

My entity (ins_submission) has a unique PK which is essentially a autonumber field and a FK (resident_Id) which has a unique index.

Wingnut wrote:

I am using the Adapter configuration. Here is the code I use in DAL 1.0

Dim sr As New ld_masterLLBL.clsLd_ins_submission sr.iResident_id = (SqlTypes.SqlInt32.Parse(resident_id)) sr.SelectOneWresident_idLogic()

My entity (ins_submission) has a unique PK which is essentially a autonumber field and a FK (resident_Id) which has a unique index.

I'd suggest you to read the section in the manual: Using the generated code -> Adapter -> Using the entity classes, in which this is discussed.

Ins_submission is = new Ins_submission(resident_id); DataAccessAdapter adapter = new DataAccessAdapter(); adapter.FetchEntity(is);