Db Object-er / News: Recent posts

A new release has been added for templates based on GenDB 2.0 (Generic ADO.NET 2.0). You can find this project on sourceForge at:

http://sourceforge.net/projects/genadonet/

It is very similar to how you would use any data provider, but the same code works for any code provider (Sql, OleDB, Odbc at least).

Let me know what you think in the forums, or when you see me post in the microsoft newsgroups! If you are near St. Louis, consider coming to my presentation at the C#.NET Sig User group meeting on September 8, 2003 (6:30pm) at the Microsoft Midwest offices.... read more

I have fogotten to include a referenced DLL used by Template03, Template04, and Template05. Each is looking for a project called GenDB. I have added this as a new project to SourceForge. It can be found at:

http://sourceforge.net/projects/genadonet

Michael Lang

As promised I updated template04 with proper databinding on the grid form. It uses the BindingContext and CurrencyManager of the grid to properly bind to the business level collection. This collection is derived from CollectionBase.

The new template (Template05) also takes advantage of new features of 0.9.1 and therefore will not work 100% with the old version (0.9.0).

The only bug I've found so far has been fixed.
-SqlDbType.NVarChar now maps to DbType.AnsiString

I also added a couple new replacement tags.
[PKDBTYPE] and [FIELDDBTYPE] both are replaced by the DbType for the fields type. [FIELDTYPE] and [PKTYPE] are replaced with the .NET framework type for the current language. The new template05 uses the new features.

Would you like to know more about the data access methodology used in the templates supplied on the downloads page? Need help structuring a 3 tier data access application? Want to know how to make your code database independant? Want to know how to use Db Object-er to accomplish all of this?

I will be presenting how to do this at the September 2003 St. Louis user group meeting.

Details: http://www.stlnet.org/sigs.htm
or: http://csharpstl.org/

The first released version (0.9) is fully functional. 4 sample template sets have also been released as separate downloads. Template set 04 is the latest developed, and is generally better quality. One deficiency in the UI tier of set 4 is lack of proper databinding to user interface controls. Proper meaning the use dataSource and dataMember properties of the controls. Instead the form templates implement data update code as the user edits the data in the controls and then sets control values based on the validated property values in the business objects. This method is fully functional, but cumbersome.... read more