BBS.PROGENIC.COM / The Scene / Scene Releases / C# Property class generator / Latest Posts

RE: C# Property class generator

lok — Fri, 06 Jun 2008 22:46:37 GMT

sample code to get customers and a bunch of tables related to them due to FK constraints:

int userID = -1; // whatever

PredicateExpression                 expression  = new PredicateExpression(CustomersFields.UserId == userID);
EntityCollection   customers   = new EntityCollection();

IPrefetchPath2 path = new PrefetchPath2((int) EntityType.CustomersEntity);
path.Add(CustomersEntity.PrefetchPathAccounts);

path.Add(CustomersEntity.PrefetchPathCountries);
path.Add(CustomersEntity.PrefetchPathCustomerAccounts).
    SubPath.Add(CustomerAccountsEntity.PrefetchPathAccounts).
    SubPath.Add(AccountsEntity.PrefetchPathTaxAccounts).
    SubPath.Add(TaxAccountsEntity.PrefetchPathTaxes);


using (DataAccessAdapter adapter = new DataAccessAdapter()){
    adapter.FetchEntityCollection(customers, new RelationPredicateBucket(expression), 1, null, path);
}

// now do something with the collection

let me know if you want some examples of other stuff.

fetching a customer based on PK is just as easy as

CustomersEntity customer = new CustomersEntity(customerID);
using(DataAccessAdapter adapter = new DataAccessAdapter()){
   adapter.FetchEntity(customer);
}

you use prefetch path to do the equiv of 'left outer joins'. i.e. it will get the other tables linked if available. you can use 'bucket.Relations.' to force an 'inner join' such that rows are only returned if everything exists. let me know if you want an example of this.

RE: C# Property class generator

proge — Fri, 06 Jun 2008 08:19:36 GMT

cool thanks, yea i read enough to realise adapter was the way to go

RE: C# Property class generator

lok — Thu, 05 Jun 2008 09:34:13 GMT

proge i didn't learn llblgen from a book or anything [company i worked at had projects in it]

i can maybe whip up a sample or two for you later [when i'm at work]

best place for llblgen,help at least, is the forums at llblgen.com

the .chm that comes with the llblgen install is also a nice place for tips/etc

we use it in adapter mode (not self-servicing). adapter is the better way.

will post some 'typical' snippets tommorow

RE: C# Property class generator

proge — Wed, 04 Jun 2008 16:01:30 GMT

lok can you point me in the direction of any resources you know that might help me learn. So far i've set it up on one of my databases and managed to use the dataadapter and a entity class.

I found this ebook http://www.lulu.com/content/174470, do you know of any other books?

@wax

have you been using linq at all? i'm a bit lost to be honest just be reading through this

http://weblogs.asp.net/fbouma/archive/2008/05/19/why-use-the-entity-framework-yeah-why-exactly.aspx

and the comments, it seems there's a firey debate raging over what is best to use and i'm trying to work out the truth between the different philosophys.

Could you explain why link2sql makes the need for stuff like llblgen redundant?

RE: C# Property class generator

silicon002 — Tue, 03 Jun 2008 02:52:36 GMT

Nice post...

RE: C# Property class generator

proge — Thu, 29 May 2008 08:13:22 GMT

cheers

RE: C# Property class generator

lok — Wed, 28 May 2008 17:35:53 GMT

proge (5/28/2008)

lok pm me with contact details, you've disabled pms.

What about LINQ and the ADO.NET Entity framework. Do you think it's worth me learning llbgen or would this be better?

http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx

llblgen has a linq to llblgen component which is much better, so i'd go with that. i'm personally not a fan on linq honestly, but frans' articles on it can be found here:

http://weblogs.asp.net/fbouma/default.aspx

RE: C# Property class generator

wax — Wed, 28 May 2008 14:06:09 GMT

Nah lok, O/R mappers are complete overkill for what this little tool was written for all this time ago.

And these days I'm not going to waste my time on a O/R mapper now that LINQ/LINQ2SQL is sorted.

(And yes, Bouma is practical but his posts are just non stop advertisements for LLBGen and flames directed at anything that's direct competition to it.. the guy invented tunnel vision)

RE: C# Property class generator

proge — Wed, 28 May 2008 12:41:12 GMT

lok pm me with contact details, you've disabled pms.

What about LINQ and the ADO.NET Entity framework. Do you think it's worth me learning llbgen or would this be better?

http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx

RE: C# Property class generator

lok — Tue, 27 May 2008 18:29:53 GMT

yeah it's easily worth the few $$ for the pro version. guy that writes it (frans bouma) is very smart/practical guy. stopped me from writing my own orm (like wax's) when i found it.

RE: C# Property class generator

proge — Tue, 27 May 2008 18:24:51 GMT

looks sexy i'm gonna play with that tomorrow, intro vid on here shows it off nicely

http://www.netfxharmonics.com/2006/03/llblgen-overview-special-edition-video.aspx

RE: C# Property class generator

lok — Tue, 27 May 2008 18:10:40 GMT

nice mate but have you seen llblgen? it's what we use at work as an o/r mapper. definitely the best around.

RE: C# Property class generator

wax — Sun, 25 May 2008 12:40:47 GMT

Download:

http://www.videoripper.net/images/DBPropertyGenerator.zip

Screenshot:

RE: C# Property class generator

wax — Thu, 22 May 2008 14:56:14 GMT

I'll dig it up and post a fixed link when I'm back from Berlin beginning of next week

RE: C# Property class generator

MGunawan — Wed, 21 May 2008 22:44:35 GMT

link is broken, can you give another link .. please

RE: C# Property class generator

godhn — Mon, 21 Nov 2005 11:12:01 GMT

now that looks handy..... cheers wax!

C# Property class generator

wax — Mon, 21 Nov 2005 08:38:10 GMT

One of the little tools I created to make life easier.

If you're like me and tend to create classes in C# as a sort of in-memory representation of a database table (e.g. a User object) then you'll know how annoying it is to type out / copy paste the fieldnames, their get/set properties and that manually.

So without further ado(.net, pun intended) I present this. Only works with SQLServer (2k/2k5).

http://www.morphed.org/dbpropgen/DBPropertyGenerator.zip

Sample output:

Code available if you want or don't trust my code (and you're too lazy to ILDASM it).

(Oh yea, it generates the var declarations line by line, I was too lazy to do that properly).

(Oh yea, it requires .net framework 2)