LLBLGen is an Object Relational Mapper (O/RM) for .NET. With it you can generate your data access layer for multiple O/RM frameworks (LLBLGen Pro Runtime Framework, Entity Framework, Linq to Sql, and NHibernate 2.x / 3.0 (hbm.xml and FluentNHibernate)).
Questions tagged [llblgenpro]
165 questions
2
votes
1 answer
LLBLGen Cascading Delete?
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…

Fishtoaster
- 1,809
- 2
- 20
- 36
2
votes
1 answer
Create (LLBLGen) Linq query dynamicly with strings
We need to generate LINQ queries which are 100% unknown during coding (design time). This is because the logic is available in our framework which is 100% separated from any data projects. For data we use LLBLGen generated data access code.
Normally…

Gabriël
- 1,323
- 2
- 22
- 34
2
votes
1 answer
Nested Select in LLBLGen
So, I have the following tables:
Using LLBLGen 2.6 (Adapter Version - No Linq), SQL Server, and .NET 3.5, how would I write the following query?
SELECT o.ObjectID
FROM Object o
INNER JOIN ObjectDetail d ON i.ObjectID = d.ObjectID
WHERE…

PostMan
- 6,899
- 1
- 43
- 51
2
votes
1 answer
LLBLGen - How to use CatalogNameOverwriteHashtable
I'm trying to join two tables from two different catalogs but I'm not able to get to work.
I know I have to do something with CatalogNameOVerwriteHashtable but apparently I'm doing something wrong.
The documentation link…

Andre Veringa
- 31
- 6
2
votes
1 answer
SQL Server 2012 XML Type Preserve Significant Whitespace
I am trying to store some data in an XML-Typed Column which, when the data is a string, will preserve the exact text and not replace or adjust embedded line-endings specifically CR & LF.
So a C# string like "A\r\nB\rC\nD" needs to come back exactly…

Simon Hewitt
- 1,391
- 9
- 24
2
votes
5 answers
can't pass default comparer as IComparer
I'm trying to call a "Sort" method that expects a parameter of type IComparer

JoelFan
- 37,465
- 35
- 132
- 205
2
votes
2 answers
LLBLGen "Flattening" Table Relations
I currently have two entities in LLBLGen and would like to merge them together to output to a table to be used in a DevExpress GridControl in the same way that 2 tables joined together with an inner join.
Does anyone know how to do this with…

Tim Almond
- 12,088
- 10
- 40
- 50
1
vote
1 answer
LLBLGen - Select against an entity-collection in memory
How can I retrieve, say, all the lineitems for all orders in a customer object?
I am trying
grdView.DataSource = customer.Orders.
but after orders, all I get is "GetMulti"...I don't see the lineitems collection.
I can understand doing this for one…

Saif Khan
- 18,402
- 29
- 102
- 147
1
vote
2 answers
Is there any way to get LLBLGen Pro to generate the generic and dbspecific .csproj files in separate directories
LLBLGen Pro by default generates the generic and db specific project files in the same root directory.
I'm trying to make my model projects use NuGet for dependancy management and this breaks/starts behaving strangely as both projects end up…

buildmaster
- 308
- 1
- 11
1
vote
1 answer
LLBLGEN - Fluent NHibernate
How do I get LLBLGEN to output to POCOs instead of .hbm.xml files?
1) I have selected the Framework as NHibernate but there does not seem to be any settings in the project properties to change the output type.
2) I thought maybe I needed to download…

user1054637
- 695
- 11
- 28
1
vote
2 answers
How to execute a custom sql statement in LLBLGen 3.1 (self servicing)?
Using LLBLGen 3.1 (Self Servicing) on SQL Server, how would one execute custom SQL, such as:
delete from UserPreference
select * from UserPreference (into a datatable, for example)

tbone
- 5,715
- 20
- 87
- 134
1
vote
0 answers
C# Dynamically Delete Relations Using LLBL
Just looking for a little help concerning LLBL and deleting related entities. I am in the process of creating a common code base and am looking to reduce the dependencies of our current Data Access Layer. In doing so, I am trying to figure out a…

Brandon.Henricks
- 11
- 1
1
vote
3 answers
Generating client-side validation from LLBLGen validation
I've been looking and it seems no-one has cracked this yet but I thought I'd ask the community here as well to see if anything came up.
Is there a way to get client-side validation (jQuery, Live Validation, whatever) to automagically get the…

William Hurst
- 2,231
- 5
- 33
- 54
1
vote
1 answer
Devart.Data.MySQL Entity Provider
I'm having an issue getting Devart.Data.MySQL set up as an Entity Provider.
What I have reached so far is this App.config: https://paste.mozilla.org/Q81ctALe
But all that does is throw this exception:
System.InvalidOperationException: 'The Entity…

Martin
- 63
- 1
- 3
1
vote
1 answer
Using LLBLGen Pro strictly as a designer for EF4
First of all - I'm fine with how EF4 works. My main concern right now is the ability to scale when I get over 100+ tables. Ideally the schema needs to be kept under the same data context. If I have to break it into subject areas it won't be very…

katit
- 17,375
- 35
- 128
- 256