LLBLGen ANGTE released on CodePlex!

June 13th, 2011

Today I published the LLBLGen ANGTE project. That is the short for LLBLGen ASP.Net GUI Templates Extended but that seems just too long :)

It’s a template set you can use in your LLBLGen projects to generate a complete database editor in ASP.NET 2.0+ using Adapter or SelfServicing generated code.

Since LLBLGen Pro v3.x now supports multiple target frameworks, it’s important to note that these templates only work for LLBLGen Pro target framework. That means you can’t use them to generate GUI for NHibernate, EntityFramework, etc., at least not for now.

GridViewThumb EportToExcelThumb ReportThumb EditFormThumb

Read the rest of this entry »

New exciting content is coming soon!

April 11th, 2011

Hi readers. First I want to apologize to you for the lack of content all this time as I’ve been very busy. The good news is that I have a lot of draft posts I will publish soon so you can see advance articles about all the good stuff that happened in the LLBLGen Pro world all this time.  This includes:

  • Release of LLBLGen Pro v3.0
    • Model First approach
    • Flexible and powerful mapping information
    • Multi target framework support (NHibernate, EntityFramework v1 and v4, Linq2Sql, LLBLGen framework)
    • Element Search
    • Typed resulset from Stored Procedures
    • Advance custom meta-data in your model
    • WCF RIA Services support
    • Much more…
  • Release of LLBLGen Pro v3.1
  • Release of LLBLGen Pro QuerySpec Beta: A new fluent query API
  • Much more…

So stay tunned as more exciting content is coming  :)

PrefetchPaths in Depth

October 1st, 2009

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.

Read the rest of this entry »

LLBLGen Pro Expressions and Scalar Queries

September 22nd, 2009

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

Read the rest of this entry »

Add custom calculated fields to LLBLGen objects

September 8th, 2009

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:

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.

Read the rest of this entry »

Change database name (catalog name) in LLBLGen Designer

September 2nd, 2009

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.

Read the rest of this entry »

Auditing in LLBLGen Pro (Text File)

August 29th, 2009

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:

Read the rest of this entry »

UpdateEntitiesDirectly with ORDER-BY and LIMIT (MySql specific)

August 25th, 2009

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

Read the rest of this entry »

Auditing in LLBLGen Pro (Introduction)

August 25th, 2009

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:

Read the rest of this entry »