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
29
votes
3 answers

What is a "Scalar" Query?

I am using LLBLGEN where there is a method to execute a query as a scalar query. Googling gives me a definition for scalar sub-query, are they the same ?
Cemre Mengü
  • 18,062
  • 27
  • 111
  • 169
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
2 answers

Decimal vs. int when using ORMs

I have been using ORM tools/code generators and I see that they prefer using decimal to int values when mapping columns to properties. Is there any advantage of using decimal ? The column type in database is the default Number which created as…
Cemre Mengü
  • 18,062
  • 27
  • 111
  • 169
4
votes
3 answers

ASP.NET MVC and LLBLGEN

Anybody aware of a best practices or example project out there that uses ASP.NET MVC and LLBLGEN (selfservicing or adaptor)? Possibly something similar to S#arp Architecture. I'm new to MVC and I'm constrained to using LLBLGEN.
vince
  • 55
  • 2
  • 7
4
votes
1 answer

How to mock with LLBLGen

How can you mock LLBLGen? I see that there is an ILinqMetaData interface but it doesn't provide any useful methods to mock out. I'm assuming you would want to program to the ILinqMetaData interface as well as the generated entity interfaces to keep…
Joe Phillips
  • 49,743
  • 32
  • 103
  • 159
3
votes
1 answer

automapper unexpected fields c#

I am trying to map a simple model to an entity but get a list of unmapped items that I was not expecting, it fails at the validation line of AutomapperCfg: SaveImportRunDetailsModel -> ImportRunDetailEntity (Destination member list)…
Tim
  • 65
  • 1
  • 5
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
2
votes
2 answers

C# Reference collection object dynamically?

So I need to access a class property's value dynamically at runtime but I can't figure out how to do this...any suggestions? Thanks! //Works int Order = OrdersEntity.ord_num; //I would love for this to work.. it obviously does not. string…
diamondracer
  • 95
  • 1
  • 8
2
votes
1 answer

LLBLGEN, how to update an existing entity

I have entity Customer under group name Customers I moved the Customer entity to a new group TestCustomers The Customer db table changes in the meantime renaming a field from LastName to Surname I do a Refresh Relational Model Data from a…
user1054637
  • 695
  • 11
  • 28
2
votes
1 answer

Can you tag generated SQL from an ORM for troubleshooting purposes?

We heavily use ORMs in our web application (EF and LLBlGen) and we have a DBA helping us improve the performance of the application by finding queries that are causing the most problems. We have a lot of linq queries accessing the database and some…
GraemeMogo
  • 41
  • 3
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

.NET ORM Adapters: LLBLGEN vs nHydrate

We are about to start development of a web application in MVC3 Razor. We are looking for an ORM that has following aspects: If you baffled or puzzled in a scenario you can easy to find a solution or consult Easy to manage updates and maintain…
Ramiz Uddin
  • 4,249
  • 4
  • 40
  • 72
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
2
votes
1 answer

LLBLGen Cascading Delete?

Is there any easy way to do what seems best described as a "Cascading Delete" in LLBLGen? An example of what I'm looking for: You've got these tables: Customer: -Id Order: -Id -CustomerId OrderDetail: -Id -OrderId Now, I want to delete a…
Fishtoaster
  • 1,809
  • 2
  • 20
  • 36
1
2 3 4 5 6