LLBLGening

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 and combine cases. I know you love code so I included code snippets on each case using LLBLGen Pro API and LINQ2LLBL. Finally I will provide some tips to avoid common mistakes.

In this article I will use LLBLGen v2.6,  Adapter TemplateSet, C#, and AdventureWorks database. The concepts and code snippets are easily portables to SelfServicing.

(more…)

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 see the data as a result from a query, so it’s helpful to see the query that reproduces the resulset.

Today I will talk about LLBLGen Pro Expressions and how they are useful when building “kind of complex” query constructs like subqueries and make operations among them. I will use IExpression, ScalarQueryExpression and DbFunctionCall within a DynamicList as the target. The code is written in C#, LLBLGen Pro v2.6, Adapter Templaset, using AdvertureWorks DB (SQLServer 2005).

(more…)

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 say LLBLGen objects that means Entities, TypedLists and TypedViews. I wont discuss entities, as Frans explained very well here (see Step 6 – Extending EntityFactory).

So, we will focus on TypedLists and TypedViews. I will use C#, Adapter and AdventureWorks2008 database.

(more…)

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 same.

In this article:

• Some things to know about the example
• The SimpleeTextFileAuditor
• Adding a new product
• Editing a product
• Deleting a product
• Updating multiple products
• Persist audit information
• References

(more…)

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) how to put custom code to get this done. I’ll use Adapter and C#.

(more…)

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 some introductory information, some of this information is quoted directly from the LLBLGen Pro Documentation, so you can go there for more detail information.

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). I will focus on the “Adapter example” that include a GUI project made in ASP.NET. Even though the SelfServicing example is pretty the same in concern to auditing functionality.

In this article:

• Background
• Requirements
• Installation
• Code at a glance
• Introduction to LLBLGen Pro Auditor classes
• References

(more…)