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
0
votes
1 answer
LLBLGen Pro: How to implement INSERT INTO... SELECT statement
I want to batch insert records with LLBLGen, following is T-SQL:
INSERT INTO Role(idt1) SELECT idt2 FROM template WHERE templateid = 1
How can I do this?

guaike
- 2,471
- 9
- 31
- 42
0
votes
2 answers
llbl stored procedure
I have a problem on llbl. I have a stored procedure in my sql database and I want to get the stored procedure code in code(C#) side with llbl.
Sql Code:
SELECT ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.Routines
WHERE ROUTINE_Name =…

John
- 386
- 1
- 7
- 22
0
votes
1 answer
LLBL GEN PRO 3.1 Select distinct two fields
Is it posible to use DefineField and AggregateFunction.SumDistinct with two fields in LLBL GenPro 3.1?
For example I have this:
ResultsetFields myFields = new ResultsetFields(2);
//I want this amount to be distinct but with specific…

Dado
- 1,016
- 1
- 12
- 20
0
votes
0 answers
Implement client server architecture with WCF for a project that has used LLBL gen pro 2.6
I have a project that was developed using LLBL GEN PRO 2.6. Its Self Hosting method is used for the project.
UI has also used the DAL(LLBL GEN PRO auto generated set of class which does most of the Business layer and 100% of the Data Access Layer…

Jude Rajasekara
- 1
- 1
0
votes
0 answers
LLBL Gen Pro Layer Exposed by WCF via DTO
I want to refactor existing windows application by introducing WCF layer in between UI and BAL.
It is used LLBL Code Gen Pro as ORM tool and it uses SelfServing method to communicate with a database.
I want to introduce WCF layer but cant change…

KDS
- 99
- 1
- 16
0
votes
1 answer
ASP.NET , LLBLGen and Spring.Net with Service Layer
So I am thinking of using LLBLGen Pro and Spring.Net on this asp.net project using a service layer to decouple the Business Logic from the Data Store. I am also considering using PONOS in the UI Layer, now my question is:
Should I Map the rich…

Luis
- 5,979
- 2
- 31
- 51
0
votes
1 answer
ORMs inheritance support
I'm trying to map two tables in one Entities as these tables is really one entity.
I've tried llblgen and Visual NHibernate without any success as both designers
Visual NHibernate can't see one to one relationship, however I've implemented…

Danil
- 1,883
- 1
- 21
- 22
0
votes
1 answer
LLBLGen: Auto generate DTO files
In my project I am using LLBLGen as ORM. I am able to generate entity objects for all the tables present in database but respective DTO objects are not getting generated automatically for all the table. I have to manually select each table and…

SKS
- 220
- 3
- 12
0
votes
1 answer
non POCO ORM in decoupled application design
I need to use LLBLGEN or EF4.
I know that it is possible to use poco with EF4, however I need to use general approach.
So my aim is to implement non poco orm and decouple it from domain.
It means that I can't use DAL entities in Domain as it will…

Danil
- 1,883
- 1
- 21
- 22
0
votes
1 answer
How does TypedList in LLBLGEN relate to a database?
I have no experience with LLBLGEN. Nevertheless, the company I work for has asked me to use it to do some stuff. They have started me off with this example code
var products = new ProductTypedList();
using (var adapter = new…

JRG
- 210
- 1
- 10
0
votes
1 answer
Generating entity files into folders per schema with LLBLGenPro for NHibernate
We have a DB with multiple schemas with the same tables in the different schemas.
Using LLBLGenPro to generate NHibernate entities.
However, LLBLGenPro falls over, complaining that there are duplicate table names.
What we want is for the entities to…

Jacques Bosch
- 2,165
- 3
- 25
- 36
0
votes
2 answers
LLBLGEN related array not populating in entity
i'm struggling with LLBLGEN and i guess ORM's in general.
i have created an entity, lets use a library example to explain:
i want to display a book object and also return a list of users who have loaned the book.
so i need to return the book object…

nologo
- 5,918
- 3
- 36
- 50
0
votes
1 answer
Generic Entity/Collection Fetching with LLBLGen DataAccessAdapter?
I have a form, which needs to have drop downs (Text and Value) populated from a database I'm accessing with LLBLGen DataAccessAdapter.
I'm using Telerik, if this provides any additional useful information or options.
Is there a way to do this…

Nol
- 344
- 3
- 15
0
votes
2 answers
I have some quite simple SQL that I can trying to change to either Linq or LLBLGEN
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…

Andy
- 305
- 1
- 4
- 14
0
votes
1 answer
llblgen pro 3 discriminator field not showing
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…

Daveo
- 19,018
- 10
- 48
- 71