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
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
2
votes
1 answer

Create (LLBLGen) Linq query dynamicly with strings

We need to generate LINQ queries which are 100% unknown during coding (design time). This is because the logic is available in our framework which is 100% separated from any data projects. For data we use LLBLGen generated data access code. Normally…
Gabriël
  • 1,323
  • 2
  • 22
  • 34
2
votes
1 answer

Nested Select in LLBLGen

So, I have the following tables: Using LLBLGen 2.6 (Adapter Version - No Linq), SQL Server, and .NET 3.5, how would I write the following query? SELECT o.ObjectID FROM Object o INNER JOIN ObjectDetail d ON i.ObjectID = d.ObjectID WHERE…
PostMan
  • 6,899
  • 1
  • 43
  • 51
2
votes
1 answer

LLBLGen - How to use CatalogNameOverwriteHashtable

I'm trying to join two tables from two different catalogs but I'm not able to get to work. I know I have to do something with CatalogNameOVerwriteHashtable but apparently I'm doing something wrong. The documentation link…
2
votes
1 answer

SQL Server 2012 XML Type Preserve Significant Whitespace

I am trying to store some data in an XML-Typed Column which, when the data is a string, will preserve the exact text and not replace or adjust embedded line-endings specifically CR & LF. So a C# string like "A\r\nB\rC\nD" needs to come back exactly…
Simon Hewitt
  • 1,391
  • 9
  • 24
2
votes
5 answers

can't pass default comparer as IComparer
I'm trying to call a "Sort" method that expects a parameter of type IComparer, using the code: collection.Sort((IComparer)Comparer.Default) It builds but at run time I get an InvalidCastException with the message: Unable…
JoelFan
  • 37,465
  • 35
  • 132
  • 205
2
votes
2 answers

LLBLGen "Flattening" Table Relations

I currently have two entities in LLBLGen and would like to merge them together to output to a table to be used in a DevExpress GridControl in the same way that 2 tables joined together with an inner join. Does anyone know how to do this with…
Tim Almond
  • 12,088
  • 10
  • 40
  • 50
1
vote
1 answer

LLBLGen - Select against an entity-collection in memory

How can I retrieve, say, all the lineitems for all orders in a customer object? I am trying grdView.DataSource = customer.Orders. but after orders, all I get is "GetMulti"...I don't see the lineitems collection. I can understand doing this for one…
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
1
vote
2 answers

Is there any way to get LLBLGen Pro to generate the generic and dbspecific .csproj files in separate directories

LLBLGen Pro by default generates the generic and db specific project files in the same root directory. I'm trying to make my model projects use NuGet for dependancy management and this breaks/starts behaving strangely as both projects end up…
buildmaster
  • 308
  • 1
  • 11
1
vote
1 answer

LLBLGEN - Fluent NHibernate

How do I get LLBLGEN to output to POCOs instead of .hbm.xml files? 1) I have selected the Framework as NHibernate but there does not seem to be any settings in the project properties to change the output type. 2) I thought maybe I needed to download…
user1054637
  • 695
  • 11
  • 28
1
vote
2 answers

How to execute a custom sql statement in LLBLGen 3.1 (self servicing)?

Using LLBLGen 3.1 (Self Servicing) on SQL Server, how would one execute custom SQL, such as: delete from UserPreference select * from UserPreference (into a datatable, for example)
tbone
  • 5,715
  • 20
  • 87
  • 134
1
vote
0 answers

C# Dynamically Delete Relations Using LLBL

Just looking for a little help concerning LLBL and deleting related entities. I am in the process of creating a common code base and am looking to reduce the dependencies of our current Data Access Layer. In doing so, I am trying to figure out a…
1
vote
3 answers

Generating client-side validation from LLBLGen validation

I've been looking and it seems no-one has cracked this yet but I thought I'd ask the community here as well to see if anything came up. Is there a way to get client-side validation (jQuery, Live Validation, whatever) to automagically get the…
William Hurst
  • 2,231
  • 5
  • 33
  • 54
1
vote
1 answer

Devart.Data.MySQL Entity Provider

I'm having an issue getting Devart.Data.MySQL set up as an Entity Provider. What I have reached so far is this App.config: https://paste.mozilla.org/Q81ctALe But all that does is throw this exception: System.InvalidOperationException: 'The Entity…
Martin
  • 63
  • 1
  • 3
1
vote
1 answer

Using LLBLGen Pro strictly as a designer for EF4

First of all - I'm fine with how EF4 works. My main concern right now is the ability to scale when I get over 100+ tables. Ideally the schema needs to be kept under the same data context. If I have to break it into subject areas it won't be very…
katit
  • 17,375
  • 35
  • 128
  • 256
1 2
3
10 11