Anybody aware of a best practices or example project out there that uses ASP.NET MVC and LLBLGEN (selfservicing or adaptor)? Possibly something similar to S#arp Architecture. I'm new to MVC and I'm constrained to using LLBLGEN. ...
I want to make custom select from the database table using Linq. We use LLBGEN as ORM solution. I can't do LINQ query to Entities Collection Class unless I call GetMulti(null) method of it. Is it possible to do LINQ query to LLBGEN without extracting all table first? BatchCollection batches = new BatchCollection(); Bat...
I have two databases (SQL Server 2005) with the same table schemes. I need to copy data from source table to destination with some modification of data along the way. And if destination table already contains some data, then rows from source table should not override, but be added to the destination table. In our project we use LLBLGen...
TL;DR: Is there some way to add an abstract method to a base class that allows derived classes to override the method's return type, without the use of generics, and without the use of the new keyword? I'm working on developing some custom templates for LLBLGen Pro. In the process, I refuse to change the default templates that LL...
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(); ...
LLBLGEN 3.0 I have two comboboxes menu sub group and menu group which I am populating using typedlist as per below code. works absolutely fine and I got this easily var adapter = new DataAccessAdapter(); IRelationPredicateBucket filter = menugroupsubgroup.GetRelationInfo(); filter.PredicateExpression.Add...
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...
Hi All, I am doing a small study about what ORM to use for our next project. I have narrowed down to LLBLGen Pro / EF4. My question is: I am more convinced about EF4. Should we use EF4 alone or should we purchase LLBLGen Pro and select EF4 as target framework? Are there any advantages/disadvantages in doing so? Any guidance/pointers...