Novick Software
SQL Server Consulting • Design • Programming • Tuning

  andy novick is a sql server mvp

 

 

Tips and Tricks for:  VB.Net, C#

The Problem:   Mapping between Business Objects and a Relational Database is difficult

Creating the Business objects and stored procedures to implement a n-Tier design is a lot of work.


Solution: Here's a list of products that can help in all or part of the process.

Commercial Products

  • DeKlarit ($899)  Take a look at a presentation regarding DeKlarit on the presentations page.
  • Lockwood Tech’s ProcBlaster ($399)
  • IronSpeed Designer ($495…$3,500)
  • VBeXpress.Net ($450)
  • RapTeir (Free…$299)
  • AlachiSoft TierDeveloper ($495-$995)
  • LLBLGenPro (Free…$195)
  • ORM.Net ($495) (Looks like it's no longer supported)
  • Pragmatier Data Tier Builder ($1250)
  • Visible Developer ($599-$1500)
  • ComExpress ($500)  This is the one that I'm using now. It generates CSLA.

Open Source, Freeware, or Shareware Solutions

  • LLBGEN (there is a paid pro version)
  • Olymeyrs
  • OJB.Net (Pre-Alpha Port of a Java tool)
  • RSDN Namespace (The Code Project)
  • Mimah (Pre-Alpha)
  • DALGen.Net (Planning Stage)
  • CsharpDataTier
  • CodeSmith (Shareware) I use this for generating strongly typed collections.

     

You also might want to take a look at:

Book Review of Visual Basic .Net Business Objects by Rockford Lhotka for more information about CSLA

My Articles on building the Stored Procedures:

   Part I: Implementing CRUD Operations Using Stored Procedures
   Part II: Implementing CRUD Operations Using Stored Procedures


RSS as HTML

Personal Blog

 
New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule