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…)

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 if the database name changed? Well, this is briefly mentioned at docs, but for some reason users can’t figure this out, so I will try to explain it a little bit more.

(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…)

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…)