Questions tagged [llblgenpro]

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)).

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…
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