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
Can I use Math.Max() / Math.Min() within a LINQ query?
I have a LINQ query which I'm using to select some rows out of a SQL database. Each row from my database represents a footprint of physical space, and I'm trying to select just the rows which contain a given point. The part of the query that is…
Max
- 808
- 11
- 25
0
votes
0 answers
LLBLGEN: Query from one table and insert in another
Let's say I want to insert values in table A, one of the columns in table A require a value which is present in table B, I wanted to know if there was a way to do this without first getting the value from table B and then saving the value in the…
Waleed Hasan
- 21
- 3
0
votes
1 answer
LLBLGEN: Load a EntityCollection or List from a datatable
How do I load an EntityCollection or List(Of Entity) from a DataTable using LLBLGen?
Saif Khan
- 18,402
- 29
- 102
- 147
0
votes
1 answer
How can I concatenate two strings into one using LLBLGen Pro
As the error says, I think LLBLGen have their own custom functions but official documentation doesn't help much. Is there any way to concatenate these two strings and make into one while LINQ querying?
var viewModelCarrierDivisionQuery = from…
sesamii seed
- 659
- 2
- 8
- 11
0
votes
2 answers
LLBLGen load a distinct item by fields that are not primary key
I have been trying to load single items from with LLBLGen by fields in the table that are not primary keys.
I can only work out how to filer on primary keys on FetchEntity.
To filter on non primary keys I am having to getthe collection and use linq…
Ashley Kilgour
- 1,110
- 2
- 15
- 33
0
votes
1 answer
Converting Oracle SQL to LLBLGEN LINQ expression C#
I have a DB of 1 table:
APP_ID|SETTING_NAME|SETTING_VALUE|ROW_LST_UPD_TS
1 |ab1 |111 |17:32
1 |ab2 |112 |17:32
---------------------------------------
1 |ab1 |111 |14:31
1 |ab2 …
Stas Yartsev
- 39
- 4
0
votes
0 answers
SQL Server - Query cancellation in "async_network_io" state
One of our customers has a very high performance server with SQL Server 2012, capable of processing large amounts of data in a very short time.
Unfortunately, the network does not seem to be as efficient.
As a client, users can set filters and query…
mcarugati
- 59
- 8
0
votes
1 answer
Unable to load custom visualizer of LLBL Gen Pro in VS19
I am using Visual Studio 2019.
To C:\Users...\Documents\Visual Studio 2019\Visualizers I have added the following dll files to enable a visualizer for predicate buckets by LLBL Gen Pro. This approach works for VS 2017.
The dll files:…
cbakos
- 323
- 2
- 9
0
votes
1 answer
llblgen pro - change stored procedure parameter name during code gen
I am using LLBLGEN Pro to generate a data layer...some of my stored procs have parameter name as "date"...so this is cauing a problem when I compile in VS2010...I have to go through the class and change the function parameters "date" to "[date]".
Is…
Saif Khan
- 18,402
- 29
- 102
- 147
0
votes
1 answer
Error while creating partial classes with LLBLGenPro
I simply am trying to declare partial classes for the tool-generated LLBLGenPro (partial) classes, so that I can use DataAnnotation for validation purposes. However, things don't seem to work here.
Following is how my code looks like :
namespace…
Gurdeep
- 123
- 1
- 13
0
votes
1 answer
LLBGen 5.3 & MS SQL Server 2012: paging query but no OFFSET xxx FETCH in generated SQL
collection.GetMulti(filter, 0, sorter, relations, path, 1, 10);
Generated SQL:
SELECT
...
FROM
((((
[NewsDB].[dbo].[Article]
INNER JOIN [NewsDB].[dbo].[OnlineArticle] ON…
ndlinh
- 1,345
- 9
- 13
0
votes
1 answer
Updating a value based on bound values during focus events in winforms
I have a WinForms form bound to a LLBLGen entity (although I believe this problem to not be specific to this binding source, I mention it just in case). My goal seems pretty simple: update another field on the form based on a calculation for the…
Godeke
- 16,131
- 4
- 62
- 86
0
votes
5 answers
LINQ ; Search with culture invariant
Here is my problem. We've got a list of enterprises, users or anything and we must search into it with a "StartsWith" search type. So on our site, we ain't got a Search field such as a Textbox but we've got a search header including 27 buttons "#",…
Simon Dugré
- 17,980
- 11
- 57
- 73
0
votes
1 answer
LLBLGen Pro- Join Vs prefetch Path
I am using LLBLGenPro for my project.I'm curious about what will be more effective way for query i.e join or prefetch path.
I observed that when I am using prefetch path,it actually firing separate queries on database with Scalable resultset where…
user19041992
- 133
- 1
- 5
- 18
0
votes
1 answer
Write contained expression in LLBL Genpro
How can i write some code with LLBL GenPro like that:
var myString = "Blah,Blah,Blah,Blah";
DbContext.MyTableName.Where(a => myString.Contains(a.TableFiledName.ToString()))
It's lambda expression with entity but now i want to do the same thing in…
Siêu Thuật Toán
- 13
- 1
- 9