Stack Overflow
Stack Overflow

Questions tagged [llblgen]

LLBLGen Pro generates a complete data-access tier and a business objects tier, utilizing powerful O/R mapping technology and a flexible task-based code generator.

83 questions
0
votes
1 answer

Entity Framework and LLBLGen

I have a database, which has two tables. The Order table, and the Item table. The relationship is m:1. I am using LLBLGen as the mapping tool to generate the source file. I can see that the ItemID from the Item table is displayed in the Order entity…
HorseKing
  • 454
  • 6
  • 19
0
votes
1 answer

What is Objectified Relationship?

I am not sure if I should be asking this here or at the programmers site. I came across "objectified relationship" while researching recursive saving in llblgen framework...I then searched stackoverflow (yes, first) and then google. I then came…
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
0
votes
1 answer

How to do a Full-Text search within a Linq query when using LLBLGen

[Using LLBLGen Pro 3.1 with Entity Framework 4, .NET 4 and SQLServer 2005] I've got a linq query that includes .Contain(keyword); IEnumerable products = null; using (var context = new ModelDataContext()) { products = (from…
Gareth
  • 33
  • 1
  • 6
0
votes
0 answers

llbl gen group by with conditional sum could not bound an Error

I am using linq query with llblgen and it's give me an error, anyone can please help me to resolved this issue. This is my query var reuslt = from cc in _metadata.TableName where cc.StdId == 125 …
Arsalan Qaiser
  • 426
  • 2
  • 7
  • 26
0
votes
1 answer

Is there anyway to use field name with concatenated from the url?

I am trying to search at the same time with pagination so I pass fieldname and fieldvalue to the url and get this. In the example below, I get the fieldname as 'firstName' and fieldValue as 'Jay'. Then I want to search like this but I get this…
dumb11
  • 129
  • 1
  • 9
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
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

LLBLGEN: How can I get only necessary list of columns with FetchPolymorphic method?

I have a list of tables and I'd like to select only necessary columns. How can I set filter witn FetchPolymorphic method?
misho
  • 1,195
  • 6
  • 16
  • 29
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

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

Creating a Moq of a static extension method from LLBLGen

i'm trying to use Moq to mock an extension method from the IDataAccessAdapter interface from LLBLGen. Here is FetchQueryAsync the extension method. Doing so gave me the error that i can't Mock static extension methods. However there is no way i can…
A1RStack
  • 75
  • 1
  • 6
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

How to map REAL Datatype in SQL with Decimal? in C#

I have written a stored procedure which returns one of the value as REAL datatype since it is referring to some old database table. I want to convert/map this value to a decimal? type in C#. However, I get an error: Specified cast not valid when…
user19041992
  • 133
  • 1
  • 5
  • 18
1 2 3
4
5 6