Main > Software Development > C, C++, C# Tools >

Data Layer Generator 1.0



 

Data Layer Generator 1.0

Sponsored Links

Data Layer Generator 1.0 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 8 (3 times)
File size: 958.3 Kb
Platform: Vista, Windows
License: Freeware
Price: Free
Downloads: 842
Date added: 2009-03-16
Publisher: Ignyte Software

Data Layer Generator 1.0 description

Data Layer Generator 1.0 is designed to save you time in developing your Visual Studio .Net applications, and to reduce the number of coding errors. This program is a code generator that will generate C# (Microsoft .Net 2.0 Framework) code that allows the business layer of an application to communicate with the data layer.

This utility allows you to easily create an object-oriented C# data layer for your SQL Server 2005/2008 database. Within approximately two minutes you can step through the three screens necessary to generate a complete set of classes for doing your basic insert, update, and delete functions on each table in the database without writing a single line of SQL code. In addition, the utility creates all the necessary stored procedures for inserting, updating, and deleting.

When you generate your data access layer, the program will create multiple classes, one for each table in your database. Each class contains methods for inserting, updating and deleting as well as properties that map to each column in the table the class represents. Each C# class represents a row in the related table and the program also produces custom collections that map to multiple records in the table.

For an easy example, let’s consider you have an existing database with one table called TCustomer. After running the utility and selecting your existing database, the program will output a class called TCustomer.cs and TCustomers.cs. The first class (TCustomer.cs) will contain properties that directly map to each column in the table so there might be a property called LastName, FirstName, and SocialSecurityNumber. This class will also have the following methods created that allow you manipulate data in that table:

  • Insert – inserts all of the properties into a new record in the database
  • Update – updates the current properties to an existing record in the database
  • Delete – removes a given record from the database
  • SelectOne – given a primary key, will retrieve one record from the database and returns an instance of the TCustomer class.
  • SelectAll – returns all the records in TCustomer in the form of an instance of the custom collection (TCustomers)
  • SelectByField – gets all records in TCustomer where the given field equals the given value and returns a collection of TCustomers

There are also some additional methods that are created when logical keys have been defined on a set of fields in a table (e.g. SelectOneByTCustomer_LogicalKeyName) and there are other methods created that handle returning child records from other tables by virtue of foreign keys (e.g. SelectOneWithTInvoices).

This utility will save you many hours of coding basic crud functionality and currently produces C# classes and stored procedures that support SQL Server 2005 and SQL Server 2008.

Major Features:

  1. Save you time in developing Programming applications
  2. Reduce the number of coding errors
  3. Generate C# (Microsoft .Net 2.0 Framework) code
    • Insert
    • Update
    • Delete
    • SelectOne
    • SelectOne
    • SelectByField
  4. Additional methods
    • SelectOneByTCustomer_LogicalKeyName
    • SelectOneWithTInvoices

Requirements:

  • Windows 2000 / XP / Vista
  • .NET Framework 2.0
WareSeeker Editor

Data Layer Generator 1.0 Screenshot

Data Layer Generator 1.0 Keywords

Bookmark Data Layer Generator 1.0

Hyperlink code:
Link for forum:

Data Layer Generator 1.0 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for Data Layer Generator 1.0. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Version History
Related Software
Takes a new approach to the infamous problem of eyestrain and Repetitive Strain Injury (RSI) - common issues concerning every type of computer abd Internet user. ErgoSense analyses how you use your co Free Download
AllKeys Macro is for users looking for a flexible but robust macro solution that allows you to record and easily edit a large number of macros. Also includes a program launcher, break timer, and mouse replacement tool. Free Download
Tool for managing and preventing repetitive strain injury (RSI). It contains an advanced trauma model that tells you to take breaks when you really need them. It contains an artificially intelligent m Free Download
Macro Recorder component provides an easy way to enable your VB, VC++, C#,VB.NET, or other COM environment applications to record and playback mouse clicks, keystrokes and bundle them into a file in o Free Download
GeekAlarm! - Keep track of when to take a break while using your computer Free Download
Stress Buster - Ergonomic product reduces the risk of RSI by reminding you to take breaks Free Download
Award-winning ergonomics software for RSI prevention and recovery. Free Download
"Ambidexter Mouse" is a utility that can let you mousing in both hands very conveniently. Mousing ambidextrously can effectively release pains that called as RSI(Repetitive Strain Injuries). If you ar Free Download