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..
If you have a database model like: and you want to edit a CustomerEntity with LLGLGen Pro, before you save the CustomerEntity, you should delete all records in the table CustomerPermission. Update a
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
If you change your database name and then open LLBLGen Pro 2.6, you can’t change you’re database name. If you choose the new database, the Project Explorer will show 2 database Catalogs. So if you
When you sort a column in a Telerik RadGrid you get the error “Cannot find column Customer”, make sure the SortExpression is the same as the DataField DataField="Customer.Description" HeaderText="Customer" SortExpression="Customer.Description" UniqueName="Customer" If SortExpression is not
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
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
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
If you have a table Order and a related table Customer, you can sort and filter this data for ASP .NET with LLBLGen pro, as mentioned in the LLBLGen Pro documentation: // Define result entitycollection
When you get the error {“The ConnectionString property has not been initialized.”} on calling a stored procedure with LLBLGen Pro, you probably forgot to set the parameter “DataAccessAdapter adapter” on you’re LLBLGen Pro methode call: