LLBLGen Pro exception: The multi-part identifier "MyDatabase.dbo.User.Name" could not be bound

0 Comments

If you get an exception like: System.Web.HttpUnhandledException (0x80004005): Exception of type ‘System.Web.HttpUnhandledException’ was thrown. —> SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of a retrieval query: The multi-part identifier "MyDatabase.dbo.User.Name" could not be bound..

Exception during SaveEntity with LLBLGen Pro

0 Comments

I wanted to update an entity with LLGLGen Pro by executing the adapter.SaveEntity() method and got an exception.   Error An exception was caught during the execution of an action query: Cannot insert duplicate key

Delete all records from a table with LLBLGen Pro v2.6

0 Comments

If you want to delete all records from a table with LLBLGen Pro v2.6 without first fetching all records, you can use the DataAccessAdapter DeleteEntitiesDirectly function. // Define the query that matches all records to

How to use datediff with LLBLGen Pro

3 Comments

If you want to use datedif to filter on a date, you can use code like: public EntityCollection<Customers> GetCustomers(DateTime creationDate) { EntityCollection<AfhaalopdrachtEntity> result = new EntityCollection<AfhaalopdrachtEntity>(); // Filter IRelationPredicateBucket filter = new RelationPredicateBucket(); IPredicate customerCreateDateFilter

Using TSQL Like operator in LLBLGen

2 Comments

If you want to query you’re database with LLBLGen, by filtering entities using the TQL Like operator you should use the FieldLikePredicate See LLGLGen v2.6 documentation: http://www.llblgen.com/documentation/2.6/hh_start.htm Specific part: http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/Adapter/Filtering%20and%20Sorting/gencode_filteringpredicateclasses_adapter.htm#FieldLikePredicate FieldLikePredicate Description compares the entity