By Data Juggler Software www.datajuggler.com .
Use our free tool RAD Studio Code Generation Toolkit or we can create, manage and host your database and data tier for you; Amazingly fast and cheap.
If you like any of my projects you can help support my web site
www.daily-click.com which is dedicated to using technology to helping people and animals; You can make a donation of any amount $3 and up or by telling your friends, family and coworkers about my web site. Daily-Click.com offers free email and text messaging
services to pet guardians and / or emerency contacts if a user does not 'Check In' at the times they selected or in the event of an emergency. Perfect for anyone who lives alone, especially pet owners and seniors.
Update Jan.1 2013: Watch the new RAD Studio Intro Movie:
You are also encouraged to download the following sample projects that were built using RAD Studio Code Generation Toolkit:
DB Compare is a utility built using C# and DataClassBuilder.Net.Dll, the same engine that powers RAD Studio Code Generation Toolkit. DB Compare compares two SQL Server databases. DB Compare was created using RAD Studio Code Generation
Toolkit, but the child has actually became more popular than the parent. DB Comare compares the database schema (tables, views and stored procedures) from two SQL Server databases and produces a report showing any schema differences.
Count Widget is a series of projects built using RAD Studio Code Generation Toolkit.
Count Widget comes with the following components:
Count Widget User Control
An asp.Net user control that references the Count Widget Web Service to make it easy to count anything.
Widget Data Web Service
The WidgetData Web Service is a web service built using RAD Studio that connects to the WidgetData SQL Server database. The Widget Data Web Service is a complete example of a WCF Windows Form hosted web service.
Count Widget Web Site
The Count Widget Web Site is a complete working copy of how to setup a web application using RAD Studio and SQL Server to create a 100% stored procedure driven data tier.
Widget Data Database
The Widget Data Database is a SQL Server 2012 (but includes scripts for older versions of SQL Server) that allow you to operate a Count Widget Web Site or the Count Widget Web Service.
Count Widget is almost done, help me test it by signing up at
RAD Studio Code Generation Toolkit
RAD Studio is the ultimate class object creator / stored procedure generator and data tier creator for C# and other Visual Studio developers.
RAD Studio is written in C# and creates a 100% stored procedure driven data tier based on any SQL Server database.
RAD Studio reads the database schema for any SQL Server database and creates a class object for all tables in the database.
The class objects created use partial classes so for each table in your databae you will have the following files created:
The business class also includes a collection class for each table so you can handle multiple instance of each type of data object.
The advantage to using partial classes is that the data class can be updated if the database model changes and the business class will not be overwritten so you can add custom properies and methods to the business class.
RAD Studio creates a 100% stored procedure driven data tier that handles the full CRUD methods so you can focus on the business rules and functionality of your application or web project.
Data Readers are code generated that load the class objects from the DataSet returned from the stored procedure.
Data Writers are created to add the parameters for any stored procedures used in your database(s).
A base class is created for each Data Writer and a derived class is used so that you may override any methods in the base class to call an alternate stored procedure if you need functionality that is not created by RAD Studio.
A stored procedure generator creates the following stored procedures for each table:
- Find returns a single instance of an object where FetchAll returns a collection of data objects.
RAD Studio uses the Microsoft Application Block for Data.
RAD Studio versus LINQ
Advantages of LINQ:
- LINQ is integrated with Visual Studio where RAD Studio is executed as a stand alone application at this time.
- LINQ has other uses in addition to SQL Server such as LINQ to XML and querying arrays and lists.
Advantages of RAD Studio:
- RAD Studio uses stored procedures where LINQ uses dynamic SQL unless you specifically call a stored procedure.
- RAD Studio creates code that is much easier to read and perfectly formatted where LINQ is very sloppy to read the code with all of the changes sets that LINQ uses to keeps track of changes in your objects.
- RAD Studio comes with Project Templates to allow you create database projects quickly.
- Since you are using code you can customize how the data is manipulated where with LINQ you do not have that ability.
- RAD Studio supports enumerations