Hi all !
I'm in the extremely lucky situation that I've just started a brand new project, in which I can choose technology. A part of the project is to replace an old Web Project written in Delphi 5 ! and a larger part is going to be new. The main bulk of the project is going to as a web application run on portable barcode readers in a production enviroment. Speed is important.
This is what I'm using:
Firebird SQL database. This is already installed and running at a lot of customers
LLBLGen Adapter DAL (2.5)
A Businesslayer project compiled into one single dll. Nearly all db access goes through here and then through LLBLGen. This is written in C# 3.0 (VS 2008 )
ASP.Net MVC on top of this.
Some part of the project consists of a Windows Forms application and the same businesslayer and LLBLGen DAL is reused there.
This works great. I love LLBLGen and the features that it present. It has save me countless of hours working with an unknown database (for me) and unknown database structure (for me).
I'm really looking forward to the LLBLGen Linq provider. I'm already using some Linq code in the businesslayer. There I'm first reading EntityCollections<> into my own List<classname> stuff and then run simple Linq sentences like this:
var packlist =
from Pack in Packages
select new { Pack.Wareno };
var WaresInOrderList =
from ware in OrderedWares
select new { ware.Wareno };
var WareInPalletButNotInOrder =
packlist.Except(WaresInOrderList);
Even though MS is creating great stuff for database handling now, it's going to be SQL Server only stuff. This is the best thing about LLBLGen. All supported databases is equal and you don't have to wait for some overloaded spare-time developer to add cool features to an open source ado-provider project.
I think that LLBLGen Pro is the best investment I've ever made since I started coding !
Have a great day, I know that I'll have just that.