How do you delete more than one entity at the same time in the designer Entities list. it seems that the designer interface only allows the selection of 1 entity at a time.... This is frustrating, is this possible? Or even deleting all entities? Thanks Regards Luis ...
I am using LLBLGen Pro 2.6. In the designer, you can easily set a field in an entity to be a .Net nullable type. When you have those same fields in a Typed List, there doesn't seem to be a way to set that same field to be a .Net nullable type. Is anyone aware if and how to do that? Thanks! ...
How could I do a simple join using LLBLGen? table1 - clientTable (address, phone, etc) table2 - employeeTable (name, etc) table3 - clientEmployeeTable (clientid, employeeid) I'm filling out a datagrid using the employeeId with fields for the client information (address, phone, etc) and I'm not sure how I could retrieve this using LLBL...
I can't seem to figure out how I can select only distinct entries in Llblgen 2.6 self-service model I essentially want this query. select distinct City from peopleTable where *predicates* I've got my PeopleCollection and I'm not sure if there's a distinct method I can call or argument I can pass to GetMulti(). ...
I'm using LLBL in a solution for both MS SQL Compact and "regular" MS SQL 2008.. I'm wondering if it's ok to use the same DatabaseGeneric project (generated by LLBL) & reference it from the 2 DBSpecific projects (generated by LLBL) targeting different MS SQL server editions? I'm planning to test it later, but the projects dependencies...
Is there any easy way to do what seems best described as a "Cascading Delete" in LLBLGen? An example of what I'm looking for: You've got these tables: Customer: -Id Order: -Id -CustomerId OrderDetail: -Id -OrderId Now, I want to delete a specific Customer and all the things that depend on it (all its orders, and all its orde...
I have the following LLBLGen code that retrieves articles by Category. Essentially it is selecting from the article table where the articles are not marked for deletion and joining on the ArticleTopicCategory table to retrieve specific categories (where category = 'string') ArticleCollection articles = new ArticleCollection(); ...
I would like to create an expression tree for a query expression that looks something like this: employee => employee.Salary.StartsWith("28") So that the sql could appear as: where (employee.salary like '28%') The problem is that the property Salary of the employee object is a decimal and StartsWith is not a property of a decimal...
We are working with LLBLGen v2.6 and trying to pull back records which do not have a certain relation. This relation is a category with a one to many mapping, and one of our entities can have zero or many categories. We want the ones with zero. We have tried the following linq query, with little success. NoCategories is a boolean intend...
We have a project that was implemented in linq to sql and is being migrated to LLBLGenPro runtime using the adapter pattern. The first version of the app did a huge amount of caching, placing entire tables into the httpcache and then doing all the linking in the codebehind. (sigh) So you get something like : from p in MyCacheObject.P...
I am trying to create 'Table per entity hierarchy' I want to set the discriminator to one of my Foreign Keys but that field does not show up in the list of available fields to pick from??? The following fields show: PK id (int) isDeleted (bool) userID fk (int) but another FK setup the same as userID but links to another table will ...
Hi All, I want to do something like this... SELECT DISTINCT T1.* FROM T1 INNER JOIN T2 ON T2.ID1 = T1.ID1 INNER JOIN T3 ON T3.ID2 = T2.ID2 --FOLLOWING CAN BE ADDED MULTIPLE TIMES (LOOPS IN C#?) INNER JOIN T2 AS T2A ON T3.ID2 = T2A.ID2 INNER JOIN T1 AS T1A ON T1A.ID1 = T2A.ID1 --END MULTI WHERE T1.ID1 = 1 AND T3.ID3 = 2 AND T3.ID4 = ...