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
1
vote
1 answer

LLbgen migration from 1.x to 5.7 version

Am working on LLbgen migration from 1.x to 5.7 version.. Am getting issues while building the newly migrated code. Below is my existing code which using the LLBLGen version 1.x public ISortExpression CreateSortExpression() { ISortExpression sorter…
Mary
  • 11
  • 2
1
vote
2 answers

Using mvc-mini-profiler database profiling with Llblgen

I am trying to integrate mvc-mini-profiler to asp.net mvc application with Llblgen used for data access. I have tried to override llblgen's CommonDaoBase.CreateConnection: public override DbConnection CreateConnection(string connectionString) { …
Adas Petrovas
  • 575
  • 5
  • 7
1
vote
1 answer

LLBLGen nested select

How can I make a nested select statment with LLBLGen? I have the following sql statement. Select * from Users where User.UserId in (select ManagerId from LnkUserManagers) Thanks in advance.
Craigjw
  • 13
  • 2
1
vote
1 answer

Can I configure LLBLGen to include generated SQL in exceptions?

I'm using LLBLGen and I have some code like so: if (onlyRecentMessages) { messageBucket.PredicateExpression.Add(MessageFields.DateEffective >= DateTime.Today.AddDays(-30)); } var messageEntities = new…
ssmith
  • 8,092
  • 6
  • 52
  • 93
1
vote
0 answers

AutoMapper LLBLGEN entity class error model to entity > -> SD.LLBLGen.Pro.ORMSupportClasses.IPrefetchPath

I use LLBLGEN, I want to map the entity class with the c # class. Mapper.CreateMap(); Mapper.CreateMap(); EntityClasses.LocationEntity loEntity =…
gsmtcnr
  • 11
  • 1
1
vote
1 answer

Can a database function be called in the predicate of a llblgen query?

I want to use a table-valued database function in the where clause of a query I am building using LLBLGen Pro 2.6 (self-servicing). SELECT * FROM [dbo].[Users] WHERE [dbo].[Users].[UserID] IN ( SELECT UserID FROM [dbo].[GetScopedUsers]…
Dan Appleyard
  • 7,405
  • 14
  • 49
  • 80
1
vote
2 answers

When will llblgenpro 3 support NHibernate 3

Google-foo is difficult when you're trying to find the answer to version support questions like this. So when will LLBLGen Pro support NHibernate 3? LLBLGen Pro 3.0 supports NHibernate 2.1. If I just use it for the POCO generation from my database,…
Jon Adams
  • 24,464
  • 18
  • 82
  • 120
1
vote
2 answers

Does LLBLGen wrap a recursive save in a transaction by default?

When saving an entity with related entities in LLBLGen, will it automatically wrap the DB calls inside a transaction, or could some portion of the save fail while other portions succeed?
newdayrising
  • 3,762
  • 4
  • 27
  • 31
1
vote
3 answers

Create expression tree for "like" on a decimal field

I would like to create an expression tree for a query expression that looks something like this: employee => employee.Salary.StartsWith("28") So that the sql could appear as: where (employee.salary like '28%') The problem is that the property…
Waliaula Makokha
  • 815
  • 1
  • 11
  • 21
1
vote
1 answer

Map LLBLGen entity to DTO

I'm trying to create a mapping between a LLBLGen Entity and a DTO using AutoMapper. My DTO's looks as followed: // Parent public int Id { get; set; } public List Children{ get; set; } // One to Many // Child public int Id { get; set;…
Sam
  • 1,303
  • 3
  • 23
  • 41
1
vote
3 answers

Inner joins using LLBLGen?

How could I do a simple join using LLBLGen? table1 - clientTable (address, phone, etc) table2 - employeeTable (name, etc) table3 - clientEmployeeTable (clientid, employeeid) I'm filling out a datagrid using the employeeId with fields for the client…
bill williams
  • 13
  • 1
  • 4
1
vote
0 answers

Can you ignore LLBLGen header comments in TFS?

I use LLBLGen Pro version 4.2 to generate my data layer and TFS to manage my source code. When LLBLGen generates my data layer it prefixes every file with a comment block like this: ' /////////////////////////////////////////////////////////////// '…
Derek Tomes
  • 3,989
  • 3
  • 27
  • 41
1
vote
0 answers

LLBLGenPro + VB6 project - accessing new columns added to a typedlist

I have a program made in Visual Basic 6 which access data from a database (made with Microsoft SQL server management studio express 2000 then migrated to 2005) and puts all data into an immense GridView. The views, typedlists, queries, etc... all…
Nuglenko
  • 11
  • 2
1
vote
1 answer

LLBLGen Pro v2.6 designer issue

How do you delete more than one entity at the same time in the designer Entities list. it seems that the designer interface only allows the selection of 1 entity at a time.... This is frustrating, is this possible? Or even deleting all…
Luis
  • 5,979
  • 2
  • 31
  • 51
1
vote
1 answer

SQL Query returns multiple rows of the same record when View includes one-to-many table

In MS-SQL, I have a View 'ListingResult' which contains rows from tables 'ListingCategoryXref' and 'Listing'. This is the View statement: SELECT dbo.Listing.ListingName, dbo.Listing.ListingId, …
Rufyan
  • 305
  • 4
  • 15