LLBLGening

PrefetchPaths in Depth

David Elizondo — Thu, 01 Oct 2009 09:00:20 +0000

LLBLGen Pro has the ability to fetch related entities together with a set of entities, e.g. fetch a set of Customer entities and also their Order entities. This feature is calledÂ Prefetch Paths. In this article I will explain how to use LLBLGen Pro PrefetchPaths. I divided its use in Cases so it would be easy to understand [...]

LLBLGen Pro Expressions and Scalar Queries

David Elizondo — Tue, 22 Sep 2009 07:56:29 +0000

Sometimes you need to reproduce monster queries in your code for display specific data or to serve data to reports. In general I prefer to say that “I need certain set of data, so How can I fetch it” instead of “How can I write this query into LLBLGen Pro”. Anyway, sometimes we used to [...]

Add custom calculated fields to LLBLGen objects

David Elizondo — Wed, 09 Sep 2009 05:15:33 +0000

Did you ever wanted to add custom fields to your LLBLGen objects based on some especial expression? Is such expression impossible to build in memory so you want it be query based? Well we will address it a little bit today. Topics on this post: Adding custom calculated field to TypedLists Adding custom calculated field to TypedViews When I [...]

Change database name (catalog name) in LLBLGen Designer

David Elizondo — Thu, 03 Sep 2009 03:53:44 +0000

Consider this: you have LLBLGen projects working and everything is just nice, life is beautiful. Then your DBA, for some reason, change the name of the database. How do you manage this as LLBLGen user? At runtime you can use Catalog Name Overwriting but What about LLBLGen Desinger? How do you refresh changes from your database [...]

Auditing in LLBLGen Pro (Text File)

David Elizondo — Sat, 29 Aug 2009 22:06:53 +0000

This is part of the Auditing in LLBLGen Pro serie of articles. These articles will use the LLBLGen Pro Auditing Example as explanation. You can download the source code atÂ LLBLGen Pro Site â€“ Examples section (Auditing example). In this article I will focus on Adapter/ASP.Net project/C# project. Doing it in SelfServiing should be almost the [...]

UpdateEntitiesDirectly with ORDER-BY and LIMIT (MySql specific)

David Elizondo — Tue, 25 Aug 2009 11:05:01 +0000

Have you ever needed to perform an update over an odered-limited subset in MySql?Â Do you use LLBLGenPro but you can’t figure out how to perform such update? If the answer is yes, then keep reading. As no all databases supports such update syntaxis, LLBLGen don’t have this built-in. In this example I’ll try to explain (briefly) [...]

Auditing in LLBLGen Pro (Introduction)

David Elizondo — Tue, 25 Aug 2009 08:49:13 +0000

Since LLBLGen Pro added this great feature, I thought would be a really nice idea to post my own experiences about it. This is the first article of the series “Auditing in LLBLGen Pro”. Why series? well it’s a little long to post in a single article In this first article I will expose [...]