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
3
votes
2 answers
LLBLGen and the repository pattern
I was wondering if building a repository on the top LLBLGen (adapter) is a good idea. I don't want to overengineer and reinvent the wheel again. The DataAccessAdapter class could be some kind of a generic repository.It has all the CRUD methods you…
user137348
- 10,166
- 18
- 69
- 89
3
votes
2 answers
LLblgen: Select distinct?
I can't seem to figure out how I can select only distinct entries in Llblgen 2.6 self-service model
I essentially want this query.
select distinct City
from peopleTable
where *predicates*
I've got my PeopleCollection and I'm not sure if there's a…
Gabe
- 5,113
- 11
- 55
- 88
3
votes
2 answers
ORA-01453: SET TRANSACTION must be first statement of transaction with LLBLGENPRO
I have searched every where in google, LLBLGenPro forums, Oracle documentation, I have successfully executed underlying insert statement in oracle and it works. I don't know how to further debug this.
Here is my code that I use to update the…
dotnet-practitioner
- 13,968
- 36
- 127
- 200
3
votes
2 answers
How does LLBLGen Pro Stack up Against Nhibernate Performance Wise
I have search the internet high and low looking for any performance information for LLBLGen Pro. None found. Just wanted to know how does LLBLGen Pro perform compared the Nhibernate. Thanks
Luke101
- 63,072
- 85
- 231
- 359
3
votes
1 answer
LLBLGen TypedConstantExpression can't be converted to SetExpression
We were experiencing issues with using over 2100 elements in a contains LINQ expression, so I have rewritten the query to insert the values previously used in the contains comparison into an IEnumerable of structs of type EnquiryID exposing a simple…
Matt Evans
- 7,113
- 7
- 32
- 64
3
votes
2 answers
How do predicate parameters work syntactically in C#?
Some Object Relational Mapping (ORM) frameworks (such as LLBLGen) allow you to specify "predicate" parameters to the query methods, such as (simplified a bit):
var entities = adapter.FetchEntities(EntityType.Employee,
EmployeeFields.Salary >…
JoelFan
- 37,465
- 35
- 132
- 205
3
votes
3 answers
Is there any way to do a Insert or Update / Merge / Upsert in LLBLGen
I'd like to do an upmerge using LLBLGen without first fetching then saving the entity.
I already found the possibility to update without fetching the entity first, but then I have to know it is already there.
Updating entries would be about as often…
StampedeXV
- 2,715
- 2
- 24
- 40
3
votes
3 answers
Should one extend or encapsulate ORM objects?
I'm having trouble understanding how to use ORM generated objects. We're using LLBLGen for mapping our database model to objects. These objects we encapsulate in another layer which represents our business model(I think).
Maybe this bit of code will…
Robert Massa
- 4,345
- 1
- 32
- 44
2
votes
2 answers
How to aggregate a collection of items in one cell of an ASPxGridView
I'm using ASP.NET 3.5, LLBLGenPro 3.0, and DevExpress 10.1.7. I have an ASPxGridView with a LinqServerModeDataSource. Each row of the ASPxGridView corresponds to a TaskEntity from LLBLGenPro. One of the properties of TaskEntity is…
RebelScum
- 549
- 2
- 5
- 19
2
votes
1 answer
LLBLGen - TransactionScope or DataAccessAdapter.StartTransaction
I see there are two main options for managing transactions with llblgen.
Method 1:
using(DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.StartTransaction(IsolationLevel.ReadCommitted, "TR");
try
{
// ...
…
JeremyWeir
- 24,118
- 10
- 92
- 107
2
votes
1 answer
LLBL: Delete Where NOT IN
I'm trying to perform the following query in LLBL and I'm not having much luck.
DELETE FROM dbo.MyTable WHERE MyTableId NOT IN ('39', '43', '44')
Essentially, I'm up to this point:
private static void Delete(MyTableCollection newRecs)
{
…
senfo
- 28,488
- 15
- 76
- 106
2
votes
1 answer
sorting on related field in llblgen 2.6
I inherited an application that uses llblgen 2.6. I have a PersonAppointmentType entity that has a AppointmentType property (n:1 relation). Now I want to sort a collection of PersonAppointmentTypes on the name of the AppointmentType. I tried this so…
John Landheer
- 3,999
- 4
- 29
- 53
2
votes
1 answer
Filtering FetchEntityCollection based on relationship collection count
I currently fetch a collection of jobs like this:
jobs = new EntityCollection(new JobEntityFactory());
var bucket = GetJobsBucket(filter);
var tempContext = new Context();
tempContext.Add(jobs);
var sorter = new…
Sam Mackrill
- 4,004
- 8
- 35
- 55
2
votes
1 answer
Join multiple times to the same table using LLBLGen
I have a table, let call it Widget, with (among others) person1id and person2id. (Yes, I suppose I should have setup a N-N relation table, but so far we never have more than 2 persons on a single widget. )
Person1Id (and person2id of course) are…
edosoft
- 17,121
- 25
- 77
- 111
2
votes
1 answer
Multiple Outer Join Condition LLBLGen
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…
user147215