Stack Overflow
Stack Overflow

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
26
votes
8 answers

nHibernate versus LLBLGen Pro

I am trying to work out with ORM tool to move over to and have narrowed it down to two candidates. nHibernate or LLBLGen Pro Please can you guys give me pros and cons in using both these tools especially if you have experience in both. I am not…
Rippo
  • 22,117
  • 14
  • 78
  • 117
12
votes
2 answers

Using Automapper to return IQueryable

I am trying to return an IQueryable object in one of my functions and using mapping (Automapper). It manage to return an IEnumerable object fine but as soon as i try to return an IQueryable object it throws me an error: This is the error: Missing…
Baahubali
  • 4,604
  • 6
  • 33
  • 72
10
votes
2 answers

How to Design Data Transfer Objects in Business Logic Layer

DTO I'm building a Web application I would like to scale to many users. Also, I need to expose functionality to trusted third parties via Web Services. I'm using LLBLGen to generate the data access layer (using SQL Server 2008). The goal is to build…
JustAProgrammer
  • 589
  • 2
  • 8
  • 17
8
votes
6 answers

SQL query slow from .NET code, but not interactively

We are using an ORM that is executing a call from .NET to SQL Server's sp_executesql stored procedure. When the stored proc is called from .NET, we receive a timeout exception. Looking at Profiler, I can see that the query is indeed taking a long…
Bret Walker
  • 1,796
  • 5
  • 20
  • 41
6
votes
1 answer

T4 For Generating POCOs Over LLBLGen Pro Entities?

As I understand it, LLBLGen Pro cannot generate POCOs over it's own entities (see here: http://www.llblgen.com/Pages/featuresLLBLGenPro.aspx). Has anyone written a T4 that will generate POCO classes corresponding to LLBLGen Pro entities and generate…
jakejgordon
  • 4,008
  • 7
  • 36
  • 45
6
votes
7 answers

Should I be concerned that ORMs, by default, return all columns?

In my limited experience in working with ORMs (so far LLBL Gen Pro and Entity Framework 4), I've noticed that inherently, queries return data for all columns. I know NHibernate is another popular ORM, and I'm not sure that this applies with it or…
Jerad Rose
  • 15,235
  • 18
  • 82
  • 153
5
votes
1 answer

How do I filter out entities that are NOT in a many-to-many relationship using LLBLGen Pro?

I have some code that is able to retrieve all entities that contain a particular relationship, like so: var bucket = new RelationPredicateBucket(); …
ssmith
  • 8,092
  • 6
  • 52
  • 93
5
votes
3 answers

the binary expression cannot be converted to a predicate expression in LINQ

I want to get the week number of a certain given DateTime. public static int WeekOf(DateTime? date) { if (date.HasValue) { GregorianCalendar gCalendar = new GregorianCalendar(); …
Florin M.
  • 2,159
  • 4
  • 39
  • 97
5
votes
3 answers

LLBLGen: How can I softdelete a entry

I have inherited a project that uses LLBLGen Pro for the DB layer. The DB model requires that when a entry is deleted a flag (DeletedDate is set to the current time). The last programmer ignored this requirement and has used regular deletes…
AdamSane
  • 2,831
  • 1
  • 24
  • 28
4
votes
1 answer

How do I join tables with a condition using LLBLGen?

I have the following Sql Query that returns the type of results that I want: SELECT b.ID, a.Name, b.Col2, b.COl3 FROM Table1 a LEFT OUTER JOIN Table2 b on b.Col4 = a.ID AND b.Col5 = 'test' In essence, I want a number of rows equal to Table1 (a)…
JamesEggers
  • 12,885
  • 14
  • 59
  • 86
4
votes
1 answer

Is it possible to serialize complex object with Protocol Buffers C# (ProtoBuf-net)

Is it possible to serialize complex object with Protocol Buffers C# (ProtoBuf-net) without using Protocontract and proto files ? [ProtoBuf.ProtoContract(ImplicitFields = ProtoBuf.ImplicitFields.AllPublic)] I have tried to use the ProtoContract but…
khorvat
  • 1,630
  • 2
  • 20
  • 31
4
votes
1 answer

Standard way to merge Entities in LlblGenPro

I start with an entity A with primary key A1, it has child collections B and C, but they are empty, because I haven't prefetched them. I now get a new occurrence of A (A prime) with primary key A1 with the child collections B and C filled. What is…
automatic
  • 2,727
  • 3
  • 34
  • 31
4
votes
2 answers

ASP.NET ORM for High Scalable Websites

Which is the best option for High Scalable Websites or Enterprise Applications: LBLGen .NetTiers LinqToSQL NHybernate Repository Pattern (CodePlex) If any other available let me know.
Michael D. Irizarry
  • 6,186
  • 5
  • 30
  • 35
3
votes
3 answers

What is the difference between llblgen and nHibernate?

What are the key differences between llblgen and nHibernate?
Blankman
  • 259,732
  • 324
  • 769
  • 1,199
3
votes
2 answers

Slow subquery IN clause?

I'm having a number of slow prefetch queries in LLBL. Here's a simplified version of the generated SQL: SELECT DISTINCT Column1 FROM Table1 WHERE Table1.Table2ID IN ( SELECT Table2.Table2ID AS Table2ID FROM Table2 …
Dan
  • 533
  • 8
  • 29
1
2 3
…
10 11