.NET tools, components, libraries and add-ins [NEW] My favorites| sign in | create your account  
ASP.NET hosting
Advertise here! Contact us to know the options

Persistence - Data-tier

Includes data-related code generation

Display options and filters
Sort by:
Built for .NET
Built for the Compact Framework
Free or free version available
Built for .NET 2
Built for Mono
Source code provided
Built for .NET 4
Library
Sold as a service
Built for Silverlight
Add-in
Discontinued

Codus

 Home Page Home Page

Categories: Code generation, Persistence - Data-tier

Author: Adapdev Technologies

Latest version: 1.4.0
Added 2004-12-09Updated 2007-04-12

Code generation tool that takes an existing database and automatically generates the code for updating, deleting, inserting and selecting records.
In addition, Codus creates web services for distributed programming, strongly-typed collections, and a full set of unit tests.
Features include:
- Supports SQL Server, Oracle, MySQL, Access
- Connection wizard
- Database properties editor (view database schema, select tables and views for generation...)
- Code generation options (VS.NET solution and projects, data access layer, table entities, strongly-typed collections, NUnit tests...)
- Template-driven output
- Template editor
- Support for NHibernate

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Source code provided
Source code provided

VBeXpress.NET

 Home Page Home Page

Categories: Persistence - Data-tier, RAD - Dev automation

Author: VBeXpress.com

Latest version: 3.0
Added 2004-02-28

Template driven code generator that can generate functional .NET applications using either VB.NET or C#. In three steps, your database classes, stored procedures, and forms will be generated from an existing SQL-Server, MS-Access, Oracle or DB2 database.

Built for .NET
Built for .NET

EntitySpaces

 Home Page Home Page

Categories: Persistence - Data-tier

Author: EntitySpaces

Latest version: 1.4.2
Added 2006-04-17Updated 2006-08-09

Persistence layer and business object system.

EntitySpaces is database-independent architecture. The data providers are loosely coupled to your application and allow you to use the same compiled code to access multiple database servers.

Features include:
- Serialization
- Dynamic Queries
- Saving via stored procedures or dynamic SQL
- Two different transaction models
- Design time data binding
- Generation from your database schema

Built for .NET 2
Built for .NET 2

MyGeneration

 Home Page Home Page

Categories: Code generation, Object-relational mapping, Persistence - Data-tier

Author: MyGeneration Software

Latest version: 1.2.0.6
Added 2004-02-11Updated 2007-04-17

Generates code from templates by combining a scripting engine with a database meta-data API.

Features include:
- supports SQL Server, Oracle, DB2, MySQL, PostgreSQL, Access, FireBird, Interbase, SQLite and VistaDB.
- can generate O/R mapping files for Gentle.NET, Opf3 and NHibernate.
- template languages supported include C#, VB.NET, JScript, and VBScript.
- templates support include files for reuse.
- each template has an optional user interface code section.
- allows the user to alias the names of tables, views, columns, relationships, etc.
- command line interface provided
- syntax editor with full Unicode support.
- plug-in support allows you to extend functionality to all templates.

Built for .NET
Built for .NET
Free or free version available
Free or free version available

Unused Stored Procedures

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Kellerman Software

Latest version: 1.1
Added 2008-09-25

Search project source code and find out which stored procedures can be removed from a SQL Server database.

Features include:
- Searches multiple source code directories at once
- Detects stored procedure dependencies
- Handles single and multi-line comments in C#, VB.NET, J#, XSD, XML, and TSQL
- Template-based drop script creation
- Detects NHibernate stored procedure usage
- Detects Enterprise Library Logging Application Block usage
- Detects DataSet stored procedure usage
- Compatible with SQL Server 2000, 2005, and 2008

Built for .NET 2
Built for .NET 2

DeKlarit

 Home Page Home Page

Categories: Persistence - Data-tier, RAD - Dev automation

Author: ARTech

Latest version: 4.0
Added 2003-05-20Updated 2006-05-11

Model-driven tool that enables you to concurrently generate and maintain the database schema, the data access and the business logic layers of your .NET-connected applications.
The DeKlarit Add-ins provide a complementary toolset to generate from components to complete presentation or web services layers.

Features include:
- Integration with Microsoft Enterprise Library 2.0 and the Composite UI Application Block
- Permission-based authentication using Enterprise Library
- Declarative layout for the Add-ins generated forms
- Auto-filtering for related foreign keys
- Referencing tables by candidate key
- Support for the .NET 2.0 Membership and Role API
- Support for Web Services Enhancements (WSE) 3.0

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Add-in
Add-in

MyBatis.NET

 Home Page Home Page

Categories: Persistence - Data-tier

Author: The Apache Software Foundation

Latest version: 1.9.2
Added 2004-04-13Updated 2007-04-11

Couples objects with stored procedures or SQL statements using an XML descriptor or annotations.

MyBATIS is a persistence layer with two main APIs: SQL Map and DAO pattern.
The SQL Mapping is used to map .NET objects to SQL statements using XML.
The DAO pattern is used for abstracting the database implementation.

Inspired by the iBATIS Database Layer for Java.
Previous names: Nausicaa, then iBATIS.NET.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

AllDb

 Home Page Home Page

Categories: Persistence - Data-tier

Author: ApexCalibur Software

Latest version: 1.0b
Added 2004-03-15

Class library providing the functionality for implementing any ADO.NET supported database using a single set of source code. AllDb provides a consistent interface across all databases. It is a set of classes that encompasses all aspects of accessing databases within the ADO.NET architecture. It’s designed to provide least common denominator support for either connected or disconnected database access.
Supported databases: SQL Server 2000, Oracle, DB2, Sybase SQL Anywhere, MySQL and Microsoft Access.

Built for .NET
Built for .NET
Library
Library
Source code provided
Source code provided

Bamboo.Prevalence

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Rodrigo B. de Oliveira

Latest version: 1.4.4.2
Added 2003-05-20

.NET implementation of the object prevalence concept brought to life by Klaus Wuestefeld in Prevayler. Bamboo.Prevalence provides transparent object persistence to deterministic systems targeting the CLR.

Built for .NET
Built for .NET
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

Warp.NET Developer Studio

 Home Page Home Page

Categories: Code generation, Persistence - Data-tier

Author: Sojourn Designs

Latest version: 1.0
Added 2004-05-05

Generates application prototypes and stored procedures.
Features:
- Generates and maintains stored procedures
- XML comment files for data access code
- Build GUI for Windows, Web, or both - using same underlying assemblies
- Generates concurrency checks for SQL Server
- Supports VB.NET, C#, SQL Server 7.0 and up, Access 2000

Built for .NET
Built for .NET
Free or free version available
Free or free version available

AgileStudio

 Home Page Home Page

Categories: Persistence - Data-tier, RAD - Dev automation

Author: Sekos Technology

Latest version: 2.2
Added 2005-02-22Updated 2005-08-31

AgileStudio extends Visual Studio .NET to accelerate the development of Windows and Web Database Applications.

Features include:
- Builds the underlying SQL database from an object model.
- Builds typed DataSets to work with your data based on your UI component choices.
- Creates the necessary data Connections and DataSet management components.
- Binds the Controls to the appropriate columns in the DataSets.
- Generates all the SQL and stored procedures to service the DataSets.
- Leverages familiar technologies like ADO.NET and Windows Forms Databindings.
- Uses standard Windows and Web Forms projects and does not require a new project type.
- Is open and extensible.

Built for .NET
Built for .NET
Add-in
Add-in

GURA OLEDB Data Gate

 Home Page Home Page

Categories: Persistence - Data-tier

Author: D2O

Can access data in any data source that implements an OLE DB Provider.
A data gate implements a standard set of methods for retrieving and saving data to a data source. When used in conjunction with the GURA Object Director or standalone within your application, the GURA OLEDB Data Gate provides the tools for getting data in and out of your data source.

Features include:
- Supports all OLE DB databases (SQL Server, Oracle, MySQL, Access, PostgreSQL, AS400, etc.)
- Database type tokens available to customise actions for specific databases
- Multiple implementations of CRUD methods
- All CRUD method available in asynchronous mode
- Supports scalar, non-query and reader calls
- Auto command generation available
- Smart caching of database information to reduce round trips
- Automatically generates procedure parameters
- Registration of in-memory data replaces database round trip
- Empty loading of tables
- Transactions are fully supported on databases that implements it
- One central data gate can provide simultaneous data gate sessions

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library

DBMethods

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Atif Aziz

Latest version: 1.0.3910
Added 2004-10-15

Library that allows you to express parameterized SQL and stored procedures as managed code functions in your language of choice (C#, VB.NET, J# and others) using the .NET Framework.
Just as Platform Invoke (P/Invoke) allows you to call unmanaged code APIs in platform libraries (DLLs) by supplying a compatible method definition in managed code, DBMethods allows you to call stored procedures and parameterized SQL in a database by defining a compatible method definition in managed code.
Unlike many products already on the market, DBMethods does not rely on templates or scriptable code generators. Instead, it makes use of the innovative features of the Common Language Runtime (CLR) like metadata, reflection services, custom attributes and dynamic code emission.

Built for .NET
Built for .NET
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

Source Cutter

 Home Page Home Page

Categories: Code generation, Persistence - Data-tier, RAD - Dev automation

Author: Razor Source

Latest version: 3.0
Added 2005-06-29Updated 2007-12-19

Source code generator for VB.NET, C#, and Java.
Source Cutter generates object to relational mappings via a data access layer, and also produces presentation layer logic by creating web pages and Windows forms for the data access layer. Source Cutter can build Web or Windows-based solutions using metadata obtained from any major database (SQL Server, Oracle, DB2, MySQL, Access, etc.).
Source Cutter also provides template based extensibility. By modifying the existing templates or creating your own templates you can alter the source code generated. The markup language used by the templates is similar to ASP or JSP-based scripting.
The JSP Generators come with freely redistributable JSP custom tags.

Built for .NET
Built for .NET

DatabaseClient

 Home Page Home Page

Categories: Persistence - Data-tier

Author: SP extreme

Latest version: 1.2
Added 2005-03-08

Set of objects providing wrappers for standard database calls.

DatabaseClient includes two objects:
- DatabaseWrapper: used to create a database connection and make SQL calls to any database using either a query or non-query based call. The wrapper also supports scalar calls. It was designed so that all the database calls incur no more overhead than directly interacting with the standard database provider methods.
- DatabaseHelper: contains a set of static methods to obtain the data you require from your database. The set of methods provide all of the same database interactions as DatabaseWrapper.

Features include:
- Supports SQL Server, Oracle, OLEDB, and ODBC.
- Supports standard database calls (ExecuteQuery, ExecuteNonQuery, ExecuteScalar).
- Returns queried data in a DataSet.
- Ability to define the connection string in the web.config file.
- Separates database interactions from your code.

Built for .NET
Built for .NET
Library
Library

Code Author

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Xin Zhao

Latest version: 1.1
Added 2007-03-12

Generates C# 2.0 classes (business/data access) and SQL Server 2005 stored procedures from a database.

Features include:
- Generates stored procedures to offer basic CRUD and search support
- Generates business object models
- Objects are serializable and bindable to .NET 2.0 data sources
- Supports standard System.Sql transactions and SQL commands
- Transactional support
- Generated code can be customized through the use of partial classes
- Strongly typed code

Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available

C# Data Tier Generator

 Home Page Home Page

Categories: Persistence - Data-tier

Latest version: 2.1.1
Added 2003-05-20

Generates SQL Server 2000 scripts for stored procedures and C# classes used to access those stored procedures. The stored proecedures generated are as follows: Insert, Update, Delete, Select, SelectByPK, SelectByFK

Built for .NET
Built for .NET

ssData

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Sheer Vision Technologies

SQL Server wrapper that includes support methods for working with databases.
ssData has methods that allow you to clean data before inserting; converting a .NET DateTime object to a SQL Server universal date time format; Boolean to SQL Server Bit conversion; dealing with DataSets, SqlDataReader; etc.

Built for .NET
Built for .NET
Library
Library

.NetTiers

 Home Page Home Page

Categories: Code generation, Object-relational mapping, Persistence - Data-tier

Author: John Roland

Latest version: 2.3.0 Beta 2
Added 2006-03-21Updated 2008-12-08

CodeSmith templates for object-relational mapping that takes an existing SQL Server or Oracle database and generates a personnalized data-access layer to use in your applications.

Features include:
- Generates ready-to-use Visual Studio projects and solution
- Integrates with the Entreprise Library application blocks architecture
- Shipped with it's own plugin, so you can configure your application directly from the entlib configuration console
- Generates business entities with a 1:1 mapping (an entity for each table or view, with a property for each column)
- Generates Data Access Layer Components (DALC) for tables and views
- Generate strongly-typed collections for entities and repositories, supporting databinding.
- Creates an ASP.NET web service for distributed programming
- Create the stored procedures script and can automatically install them on the server
- Generates a NAnt build file, to compile, test and generate chm/html API documentation

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

SoProMach

 Home Page Home Page

Categories: Code generation, Persistence - Data-tier

Author: Somusar

Latest version: 31jan05
Added 2005-03-02

The Software Production Machine (SoProMach) is a software generation engine providing a foundation for specialized code and documentation generators. It's a generalized, language-neutral, multiplatform software source code and documentation generator, capable of accepting several input formats, such as XML, CSV, plain text, and Sisendel EF (entity files), a new textual multitier entity design language for describing metadata.

Several SoProMach-based generators are available for different purposes and target platforms: .NET (C#, VB.NET, ASPX), J2EE, J2SE, PHP, SQL, XML, HTML, etc.

Sopromach is made up of two components:
- Sisendel: SImple Software ENtity DEsign Language. It is a high-level, declarative language to design multi-tier entities and consistently generate database, logic, user interface and documentation files from one textual multi-facet definition.
- Tefigel: TExt FIle GEneration Language. This is the generic low-level file generator or templating machine of Sopromach. It also has built-in list processing and XML/HTML parsing capabilities.

SoProMach can be integrated with any IDE providing support for external tool invocation. IDE integration of SoProMach has been tested with: Eclipse 3, Visual Studio 2005 Beta, Visual Basic Express 2005 Beta, JBuilder X, CodeWarrior Development Studio v2.8.

SoProMach is available for the following platforms: Linux 2.4 (or higher) on x86; Mac OS X 10.2 (or higher) on PowerPC; Windows 2000/XP on x86.

Built for .NET
Built for .NET
Free or free version available
Free or free version available

Karvonite

 Home Page Home Page

Categories: Persistence - Data-tier

Author: AdventurerLand Entertainment

Latest version: November 2007 CTP
Added 2006-12-05Updated 2007-11-06

Persistence framework that persists object data to an object library.

Features include:
- Visually define which classes and properties (in your code) you want to persist.
- Requires no interfaces or base classes for persisting objects.
- Supports most of the basic CLR types.
- XNA Framework support (Windows and Xbox360 versions).

Built for .NET 2
Built for .NET 2
Built for the Compact Framework
Built for the Compact Framework
Library
Library
Free or free version available
Free or free version available

Monstarillo

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Yellow Bridge Software

Latest version: 1.2
Added 2004-03-09

Generates the plumbing for your SQL Server database application. It can work off of your database schema to create stored procedures to select, insert, update and delete your data as well as the code needed to call these stored procedures or it can use your existing stored procedures.
Generates 3 flavors of code:
- Data layers returning a custom Info class in addition to DataTables and DataReaders. Two different info objects are used depending on the template group selected. One uses native types while the other uses Sql Types.
- Data layers returning DataTables and DataReaders.
- Code using Microsoft Data Application Blocks 2.0

Built for .NET
Built for .NET

Enterprise Library

 Home Page Home Page

Categories: Caching, Persistence - Data-tier, Security, Tracing - Logging - Monitoring

Author: Microsoft

Latest version: 5.0 - April 2010
Added 2005-02-10Updated 2010-05-06

Library of application blocks designed to assist developers with common enterprise development challenges. Application blocks are a type of guidance, provided as source code that can be used "as is," extended, or modified by developers to use on enterprise development projects.
Application blocks help address the common problems that developers face from one project to the next. They are designed to encapsulate the Microsoft recommended best practices for .NET-based applications. They also address scenarios not directly supported by the underlying class libraries.

Contains the following general purpose application blocks:
- Caching Application Block: incorporate a local cache in applications.
- Cryptography Application Block: incorporate hashing and symmetric encryption in applications.
- Data Access Application Block: incorporate standard database functionality in applications.
- Exception Handling Application Block: developers and policy makers can create a consistent strategy for processing exceptions that occur throughout the architectural layers of enterprise applications.
- Logging Application Block: include standard logging functionality in applications.
- Security Application Block: incorporate authorization and security caching functionality in applications.
- Validation Application Block: allows you to centrally define validation rules using configuration or attributes, and validate data from anywhere in your application, including integration with Windows Forms, ASP.NET and WCF.
- Policy Injection Application Block: provides an approach for separating cross-cutting concerns from business logic using declarative policies that are attached at runtime to methods on your objects.
- Unity: dependency injection container

Also includes:
- The Application Block Software Factory: simplifies the process of building application blocks and providers through guidance automation.
- Visual Studio-integrated configuration editor: edit Enterprise Library configuration files directly within Visual Studio.

Enterprise Library also includes a set of core functions, including configuration, instrumentation, and object builder services. These functions are used by all other application blocks.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Built for .NET 4
Built for .NET 4
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

Data Abstract

 Home Page Home Page

Categories: Persistence - Data-tier

Author: RemObjects Software

Latest version: 5.0.35.741
Added 2009-01-06

Multi-tier framework for .NET and Delphi.

Features include:
- Build scalable cross-platform multi-tier database solutions for .NET, Mono, 32- and 64-bit Windows and Linux
- Target different database layouts or systems using a common code base
- Use the RAD Schema Modeler to model the structure of your data as it will be exposed to the middle- and client-tier
- Support for C#, Oxygene, VB.NET and Object Pascal
- Support for Silverlight web clients
- Abstraction of different databases types and layouts
- Strongly typed data tables and business helper classes
- Business rules scripting
- Suppors SQL Server 2000/2005/Compact Edition, Oracle, DB2, InterBase/Firebird, Sybase, PostgreSQL, MySQL, SQLite

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Built for Silverlight
Built for Silverlight
Built for Mono
Built for Mono

EasyObjects.NET

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Noonan Consulting

Latest version: 2.0 CTP
Added 2006-05-09

Object-relational mapping library built on top of Microsoft's Enterprise Library and the Data Access Application Block (DAAB).

Features include:
- Data providers loosely coupled to your application and allow you to use the same compiled code to access multiple database servers
- Bulk saving
- Support for transactions
- Dynamic connection strings
- Dynamic query syntax; Support for custom dynamic query providers, controlled by configuration file
- Code-generation scripts for the MyGeneration code generator
- XML Serialization
- Saving via stored procedures or dynamic SQL
- Generation from your database schema
- Support for SQL Server and Oracle

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available

CG Pro

 Home Page Home Page

Categories: Code generation, Persistence - Data-tier

Author: RFG Software

Latest version: Aug 2004
Added 2004-09-01

Produces n-tier applications that manipulate data within existing SQL Server databases. These applications can be produced in either VB.NET or C#.
Features include:
- support for adding and working with multiple databases
- template driven code generation allowing customisation of the generation output
- support for Windows Forms, ASP.NET, web services.

Built for .NET
Built for .NET

Objecto

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Crainiate

Latest version: 1.0
Added 2007-02-09

Designed to create n-tier data classes that are reusable, inheritable and scalable, that automatically persist themselves to the database of your choice.

Features include:
- Define and modify the structure of your data using classes and attributes in Visual Studio 2005 or any other tool that supports .NET Framework 2.0 or later
- Persist objects to an underlying database without writing repetitive data access code
- Inherit from a base class or implement an interface
- On-the-fly generation and reuse of stored procedures for all data access
- Encapsulate query logic into reusable query classes. Create fully object-orientated queries without the use of inline SQL
- Supports object inheritance of persisted classes. Allows you to add properties to create more specialized objects.
- Stateless implementation for scalability across multiple servers
- Built-in .NET remoting provider (Enterprise Edition only)

Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

Vanilla DAL

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Latest version: 0.2.2
Added 2006-11-14

Data-access framework for RDBMS on top of ADO.NET.

Features include:
- Database independence
- SQL externalization via XML
- Automatic transaction management
- On-the-fly SQL generation for DataSets
- Convenience implementations for ever recurring tasks

Built for .NET
Built for .NET
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

C# Code Generator

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Gordon F. Weis

Latest version: 2006-27-04
Added 2003-05-29

Generates a C# class from an SQL database table, and forms to collect the information.

Built for .NET
Built for .NET

Visible Developer

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Visible Systems

Generates business and database access logic for typical business applications.
Import data models from existing databases then define your business objects with the modeling features.
Code patterns translate the model into code for VB6, ASP, C#, VB.NET and ASP.NET.

Built for .NET
Built for .NET

DataStreams

 Home Page Home Page

Categories: Persistence - Data-tier, Reporting

Author: Bruce Dunwiddie

Latest version: 4.0
Added 2005-02-22Updated 2007-03-26

Library of components designed to allow you to read, write, and bulk insert several common file formats including csv, xls, xml, and fixed width.
Components work with the SqlBulkCopy class to allow for DTS like speed during bulk inserts. Readers allow for record by record looping and data manipulation.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Source code provided
Source code provided

Sharp Code Foundry

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Sharp Developer

Latest version: 2
Added 2004-11-03

Visual Studio add-in that can be used to generate stored procedures and data access methods.
The code generated by this tool can be customized to match various aspects of the users coding style from naming conventions to error handling techniques.
SQL Server 7/2000 stored procedures are created based on a series of C# script files that can be customized by the user to control the output so it will adhere to development standards. As the developer procedes through the process of creating stored procedures there are options to alias parameters and tables.

Built for .NET
Built for .NET

NeuralBuild

 Home Page Home Page

Categories: Persistence - Data-tier

Author: NeuralLimits

Latest version: 1.2
Added 2006-10-04

Code generator that automatically generates Java, PHP and C# source code for accessing relational databases.
NeuralBuild generates code for Java and PHP with the Data Access Object (DAO) design pattern (DAO is a core J2EE design pattern), for C# NeuralBuild generates code for the DALC (Data Access Layer Components) pattern.

For C#, NeuralBuild generates a DALC tier based on .NET database connectors and SQL calls. The DALC components hide the invocation and format idiosyncrasies of the database from the calling application. DALC components provide an encapsulated data-access service to these applications.

Built for .NET 2
Built for .NET 2

ADO.NET Express

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Pharaoh Software

Latest version: 1.2.0
Added 2004-11-27Updated 2005-01-03

Add-in for Visual Studio .NET 2003 that generates class methods for calling stored procedures and executing common types of SQL statements.
ADO.NET Express looks similar to Server Explorer. You can add database connections and browse schema objects such as tables and stored procedures. You can right click on a schema object to generate ADO.NET code for this object. For example, you can right-click on a stored procedure and generate a C# method that executes this stored procedure and returns a DataReader. ADO.NET Express has a variety of options for generating code that cover most of the common data access scenarios.
Features include:
- Code generation in C# and VB.NET.
- Support for SQL Server and Oracle.
- Common SQL statements can be generated for tables, foreign keys and views.
- Method is generated with typed parameters that correspond to stored procedure parameters.
- Support for output and input/output parameters for stored procedures.
- Support for transactions.
- Generated code can be used as a template for modification.

Built for .NET
Built for .NET
Add-in
Add-in
Free or free version available
Free or free version available

Iron Speed Designer

 Home Page Home Page

Categories: Persistence - Data-tier, RAD - Dev automation

Author: Iron Speed

Latest version: 5.2
Added 2003-08-02Updated 2008-07-17

Application generator for building n-tier .NET web applications.
Iron Speed Designer works by translating a declarative description of your application into a working n-tier application with well-partitioned service layers including: the presentation layer, the application layer, the database layer.
Iron Speed Designer guides you through all the steps: selecting database tables, creating Web pages, adding page controls, and customizing the resulting application.

Features include:
- Web page editing and customization
- Support for third-party controls
- Code customization
- Support for Visual Studio 2003, 2005 and 2008
- Support for C# and VB.NET
- Support for Microsoft Access, SQL Server 7/2000/2005, MSDE 2000, Oracle 9i and 10g, MySQL 5.0 and 5.1

Features for generated applications:
- Custom page layout
- Filtering, sorting and navigation
- Internationalization & Localization
- Source code generation

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available

Virtual Data Objects

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Infralution

Latest version: 1.1
Added 2005-11-02

Lets you use classic ADODB recordsets as .NET data sources.

With Virtual Data Objects, you can set up a DataGrid to display browsable, editable and sortable data straight from your database. No need for DataAdapters, DataSets, etc.
Records are only loaded from the database as needed so you can browse large databases without the overhead of preloading everything into a Dataset - just like you did with classic ADO.
You can use either untyped recordsets (like classic ADO) or you can define fully typed data access classes to encapsulate access to database fields.

Built for .NET
Built for .NET
Library
Library

Evaluant Universal Storage Services

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Evaluant

Latest version: 0.9.1
Added 2006-09-25

Evaluant Universal Storage Services (EUSS) is an extensible programming model and runtime components for building data-aware solutions.
With EUSS you can access any type of data (XML, RDBMS, Objects, ...) with the same code.

Features include:
- Object-Relational mapping enabling you to reuse an existing database
- Generic relational datastore
- In-Memory Database (IMDB)
- Remote storage for making distributed applications
- XML-based configuration
- Domain model management using three different techniques: code generation with ability to import major UML case tools files, dynamic Proxy for importing your own domain classes, debuggable Aspect Oriented Programming
- Provider-based architecture
- Cache provider
- RDBMS provider independance
- Visual Studio 2003 and 2005 integration

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Add-in
Add-in
Free or free version available
Free or free version available
Source code provided
Source code provided

SQLDataLayer

 Home Page Home Page

Categories: Persistence - Data-tier

Author: JTN Development

Latest version: 1.0
Added 2006-04-24

Tool designed to script your stored procedures and optionally generate the code for the data access objects of your .NET application that utilizes a SQL Server database.

Built for .NET
Built for .NET

Dali

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Revelation Technologies

Latest version: 2.2
Added 2004-12-21Updated 2006-12-05

Object-relational mapper and data access layer.
Dali is self-configuring, analyzing your database and object model and dynamically creating all necessary SQL. Dali can use existing business objects with little or no modification. Or, the included Dali Studio GUI utility can automatically generate data class code and stored procedures appropriate for your data model.

Features include:
- Supports stored procedures and parameterized queries
- Supports deep loading and saving of nested objects
- Supports generics for type safety; Supports .NET nullable types
- Supports saving and loading Web Forms directly
- Can use existing business objects
- No mapping files to get out-of-sync
- No SQL, OQL, IQL or other languages to learn
- No code generation or reverse engineering required
- Able to use a DataSet as a data store
- Raises events when objects are loaded or updated

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library

Entity Developer

 Home Page Home Page

Categories: LINQ, Persistence - Data-tier

Latest version: 2.20
Added 2009-09-15

LINQ to SQL and Entity Framework modeling and code generation tool.
Entity Developer allows you to design an entity model from scratch or reverse-engineer an existing database. The model is used to generate C# or VB code with predefined code templates. You can customize the templates to fit your needs.

Features include:
- Design entity models for ADO.NET Entity Framework and LINQ to SQL
- Visual schema modeling
- Customizable user interface
- Reverse engineering (database object to entity model)
- Predefined and custom templates for class generation, with a template language for custom templates
- GUI for predefined and custom templates
- Diagram with zooming, overview, and printing
- Undo/Redo support
- Visual Studio is not required
- Supports SQL Server, Oracle, MySQL, PostgreSQL, and SQLite

Available in three editions: SQL Server, Express, dotConnect.

Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available

RapTier

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: SharpPower

Latest version: 1.4.2
Added 2003-06-05Updated 2003-11-11

Template-based C#, VB.NET, and SQL code generator for multi-tier development.
Key features: Object-Relational Mapping; Generation of WebForm and WinForm UI; Extendable templates; Transactional support; Support of DataTable objects; Data paging; Multi-database support: SQL Server, Access, Oracle, MySQL; Stored procedures generation; .NET data provider independent access.

RapTier is available in three editions: Lite, Professional and Enterprise. The light edition is free.

Previous name: 2LKit nTier Builder.

Built for .NET
Built for .NET
Free or free version available
Free or free version available

LLBLGen

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Solutions Design

Latest version: 1.21
Added 2003-05-20Updated 2003-07-14

Generates a complete data-tier (both .NET classes (in C# or VB.NET) and all necessary stored procedures) for a given SQLServer 7/2000 database.

Built for .NET
Built for .NET
Free or free version available
Free or free version available
Source code provided
Source code provided

TCDesigner

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Program Solutions LLC

Generates database access layer in C# and CRUD stored procedures.
Supports SQL Server.

Built for .NET
Built for .NET

Apex SQL Code

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Apex SQL

Generation tool for SQL Server 7 or 2000 that enables you to automatically generate ASP, VB, C#, SQL code.
The key feature of Apex SQL Code is template-based code generation that allows users to configure custom code patterns automated with a scripting language (VBScript or JScript).
Features include:
- Template wizard
- Yemplate property page for editing templates in place with picklists and dialogs
- XML based templates
- Built in Session and Application variables.
- Programmatic control of file operations and dialogs from the template
- Template library including C#, VB.NET, AsP, VB, SQL and Delphi templates
- Intellisense to navigate the object model

Built for .NET
Built for .NET

NextGeneration

 Home Page Home Page

Categories: Persistence - Data-tier, RAD - Dev automation

Author: Rad Software

Latest version: 1.2.1
Added 2007-02-20

Tool for building database-driven applications.
NextGeneration generates stored procedures, data access objects, business service classes, DataSets and ASP.NET web interfaces.

Features include:
- Comes with n-tier solution templates for C# .NET, VB.NET and SQL
- Generates files in batch
- Does not overwrite existing files (unless configured to do so)
- supports SQL Server and Access databases
- Designed to work with Visual Studio (designer compatible code)

Built for .NET
Built for .NET

FileHelpers

 Home Page Home Page

Categories: Persistence - Data-tier, Reporting

Latest version: 2.0
Added 2006-03-01Updated 2007-04-10

Framework to import/export data from fixed length or delimited files.

Features include:
- support for importing/exporting data from different data sources like Excel, Access, SQL Server, etc.
- Auto Converters: set of converters for the basic types; can be extended to provide custom converters
- Run-time Classes: create your record class at run-time, load them from files with source code or an XML description
- Master-Detail: read and write records with a master/detail pattern
- Multiple-record format support: read files with different record layout; you can also read files with some delimited and some fixed-length records
- Event support: The engines of the library contain some events to let you extend the behavior of the library
- Excel Storage: extract/insert records between any source and an Excel file
- DataLinks: extract/insert records between a database and a file
- GenericDataLink: copy records between two Data Storages
- Asynchronous Mode: read line by line and not a whole file
- File Transform Engine: convert files in one format to another
- Progress Notification: get notified of the progress in each operation in the library
- FileDiffEngine: compare files with the same record layout

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Built for the Compact Framework
Built for the Compact Framework
Built for Mono
Built for Mono
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

Persistent Datasets

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: The Last Component

Latest version: 2.0.3
Added 2005-09-13Updated 2006-10-21

O/R mapper and persistence layer generator based on the native DataSets with integrated native queries engine.

Features include:
- Allows writing 100% typed code using typed queries technology similar to DLINQ
- Supports DataSets and Domain Objects patterns.
- Mapping to tables, views, and stored procedures including procedure’s result sets
- Keeps your application code synchronized with database modifications
- Offers n-tier workflow including GUI binding
- Supports database identities, sequence generators
- Optimistic concurrency using database timestamps and locking fields
- Visual Studio integration including SourceSafe support
- Transactions
- Generating enumerations for basic tables
- Nullable generics support
- Inheritance
- Cascade load, save, update, delete and insert of hierarchical data
- SQL Server, Oracle support
- C#, VB support
- Cache by query
- Clustered cache
- ASP paging support
- DataSets inheritance

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Add-in
Add-in
Source code provided
Source code provided

tangible architect

 Home Page Home Page

Categories: Modeling - Architecture - MDA - UML, Persistence - Data-tier

Author: tangible engineering

Latest version: 2.0
Added 2004-01-15Updated 2005-06-08

Generates the object-oriented database access layer of the application and its database schema from within Visual Studio.
The object model's specification can be defined in code by means of attributed C# interfaces, use of wizards or by means of an UML model. The object model and database schema can be modified using the integrated object model browser. Code changes can be synchronized to the UML model using round-trip engineering.
The generated object model realizes a connection-oriented architecture with a pessimistic locking strategy. It is optimized for data-bound controls. The object-oriented database browser adds additional value to the product.

Built for .NET
Built for .NET
Add-in
Add-in

OQL.NET

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Macrobject Software

Latest version: 2.0.0.1087
Added 2006-11-08

OQL.NET (Object Query Language for .NET) is an object-oriented and strongly-typed database query language based on native .NET language (e.g. C# and VB.NET) instead of on strings.

Features include:
- Imitates the style of a SQL statement
- Supports all the major elements of SQL DML, including select, insert, update and delete statements, and select, from, join, on, where, group by, having, order by and case clauses
- Checks syntax as compile-time
- Supports SQL Server, Access, Oracle, MySQL and most databases compatible with the SQL-92 standard

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Source code provided
Source code provided

Visual Welder

 Home Page Home Page

Categories: Code generation, Persistence - Data-tier, RAD - Dev automation

Author: sembleWare

Latest version: 2.0
Added 2003-10-28

Add-in for Visual Studio .NET that allows you to snap in and snap out parts for your system in an assembly process.
By dragging and dropping at a screen level or business part level, your system virtually assembles itself.

Features include:
- full integration between database, middle tier, and Web forms
- reverse engineering from a database
- dynamic code and database generation
- 3D Spatial Editor
- active toolbox
- access to the Online Part Catalog

Built for .NET
Built for .NET
Add-in
Add-in

Gentle.NET

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Morten Mertner

Latest version: 1.2.9
Added 2004-02-06Updated 2005-02-22

Database-independent object persistence framework written in C#.
Gentle.NET features automatic SQL generation and object construction, a caching subsystem, an SQL factory for creating custom queries, a list class for managing 1:n and n:m relations, concurrency control, data binding support, and more.
Gentle.NET supports a wide range of databases and runs under both MS.NET and
Mono. Metadata is automatically extracted from the database backend, which minimizes the amount of configuration required.

Built for .NET
Built for .NET
Built for Mono
Built for Mono
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

SubSonic

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier, RAD - Dev automation

Latest version: 2.0.3
Added 2007-04-10Updated 2007-09-15

Toolset that helps a website build itself.

SubSonic's core is:
- A Data Access Layer (DAL) builder that requires no code on your part. It builds itself at compile-time with a full object layer and strongly-typed collections.
- A utility toolset, with Rails-like scaffolding, migrations (DB Versioning), and code generators.
- A dynamic query tool, that lets you use SQL Server and the Enterprise Library without having to know SQL.
- An O/R mapper that extends to views and stored procedures.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

Diamond Binding

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Dunn & Churchill

Latest version: 1.2.1.3
Added 2007-10-29

Data layer tool for Visual Studio 2005, and SQL Server.

Diamond Binding provides an add-in for Visual Studio 2005 that allows selection of tables from your SQL Server 2000+ database to be available in code following the Active Record pattern. It keeps the definitions of mapped objects synchronised in partial classes (similar to the form designer) with little generated code.
The API provided by the Diamond Binding runtime supports CRUD operations on objects, relationships, complex and simple queries, lazy loading, cascades and more. Diamond Binding supports generics, so all interactions with your data layer occur in a type-safe fashion. Schema changes are then found at compile time, rather than deployment.

Built for .NET 2
Built for .NET 2
Library
Library
Add-in
Add-in
Free or free version available
Free or free version available

Business Logic Toolkit

 Home Page Home Page

Categories: AOP, Miscellaneous, Persistence - Data-tier

Latest version: 3.1
Added 2009-10-02

Library of helpers.

Includes:
- Aspects
- ObjectBinder
- DbManager: high-level data provider independent wrapper for ADO.NET. Designed to simplify working with database and encapsulates most of ADO.NET objects such as Connection, Transaction, Command, and Parameter in one single object.
- Data accessors
- EditableObjects: classes that can help you to make your object model editable.
- Mapping: map DB source to object, map object to object, map enum to value, map value to enum, map to JSON.
- Reflection helpers
- TypeBuilder helpers
- Validation helpers

Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

Huagati DBML/EDMX Tools

 Home Page Home Page

Categories: LINQ, Persistence - Data-tier

Author: Huagati Systems Co.

Latest version: 1.82
Added 2008-08-21Updated 2009-12-11

Add-in for Visual Studio that adds functionality to the LINQ to SQL (DBML) diagram designer, and to the ADO.NET Entity Framework designer in Visual Studio 2008 and 2010 (beta 2).

Features include:
- Synchronize LINQ to SQL models with the underlying database and any database schema changes
- Mass-rename LINQ to SQL and Entity Framework generated entity classes and their members to use .NET naming conventions
- Generate documentation comments for L2S and EF entity classes from the database
- Generate SQL-DDL scripts from LINQ to SQL and Entity Framework models

Built for .NET 2
Built for .NET 2
Built for .NET 4
Built for .NET 4
Add-in
Add-in

Thycotic.Data

 Home Page Home Page

Categories: Persistence - Data-tier

Author: Thycotic Software Ltd

Latest version: 0.9
Added 2004-02-23

Data access layer for .NET that utilizes late binding and allows use of any ADO.NET provider (and database) without references.
Features:
- Use the same code against any database
- Avoid including unnecessary ADO.NET providers with your application
- Avoid the need for references to your ADO.NET providers
- Write code that will still work with future unknown ADO.NET providers

Built for .NET
Built for .NET
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

OpenNETCF Application Blocks

 Home Page Home Page

Categories: Caching, Miscellaneous, Persistence - Data-tier, Tracing - Logging - Monitoring

Author: OpenNETCF.org

Latest version: 1.0
Added 2005-06-16

The OpenNETCF team has worked with the Patterns & Practices team at Microsoft to provide a version of the Application Blocks for the .NET Compact Framework. Included in the OpenNETCF Application Blocks set are Data Access, Exception Management, Caching, and the Offline blocks.

Built for .NET
Built for .NET
Built for the Compact Framework
Built for the Compact Framework
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

DataLG

 Home Page Home Page

Categories: Persistence - Data-tier

Latest version: 1.6.0.0
Added 2006-05-16

Generates a data layer for your VB and C# applications.
DataLG supports Microsoft Access 2000/XP and SQL Server/MSDE 2000.

Built for .NET
Built for .NET
Free or free version available
Free or free version available
Source code provided
Source code provided

Code Complete .NET

 Home Page Home Page

Categories: Persistence - Data-tier, RAD - Dev automation

Author: XML Gateway

Latest version: 2.0
Added 2007-03-12Updated 2007-09-05

Template-driven code generator that can generate full applications in both C# and VB.NET.
Code Complete .NET can generate data entry web, win forms, businnes objects and lists based on CSLA.NET framework and data access objects.

Features include:
- Generates (secure and with role based security if required) single tier ASP.NET applications, single tier Windows applications or three-Tier applications in C# and VB.NET
- Generates business objects with full validation based on the CSLA.NET framework
- Generates a corresponding data access object for each business object to perform the CRUD operations
- Support for parent/multiple children relationships
- Round-trip development without losing code changes
- Support for SQL Server, Oracle and any database that has an OLEDB provider or an ODBC driver
- Integrated as an add-in within Visual Studio 2005

Built for .NET 2
Built for .NET 2
Add-in
Add-in

CodeNGen

 Home Page Home Page

Categories: Code generation, Persistence - Data-tier

Author: CodeNGen

Latest version: 1.0.3144
Added 2008-12-08

N-tier code generation tool that creates data driven applications.
CodeNGen utilizes table structures and relationships in an SQL Server database to generate C# business entities, data access code, and stored procedures. The result is a combination of base classes and object specific code that provide data support to your applications such as data binding, recursive data operations, transactions, concurrency, and unique constraint enforcement.

Features include:
- No templates to configure
- Drag and drop generated code from CodeNGen directly into Visual Studio
- Stored procedures or embedded SQL (parameterised queries prevent SQL injection attacks)
- Optimistic concurrency
- Builtin automatic database transaction support between business entities
- Recursive data operations
- Data Factory Architecture allowing database provider changes to be made in as few as one configuration file change
- Strongly typed business entities and collections have full data binding support
-Collections implement IList, ICollection, IEnumerable, IBindingList, IComponent, ITypedList, and IXmlSerializable
- Objects implement IEditableObject, INotifyPropertyChanged, and IXmlSerializable
- Unique constraint enforcement (can be disabled)
- Centralized business logic
- Business logic enforcement on save (can be disabled)
- Collection sorting
- Field denormalization for easy data binding
- Source code for all base classes is included and is fully overridable in derived classes

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Ignore this
Advertise here! Contact us to know the options
Help the .NET community get a consensus on great tools. Display your favorite tools on your own website or on your blog.
Keep track of your favorite tools. Build your personal watch list.
Advertise here! Contact us to know the options
Discontinued tools
Hosted by Arvixe
part of the metaSapiens network: metaSapiens | .NET Jobs | Fabrice's weblog | .NET tools | Java tools | Tuneo | LINQ book | MapShares | BD indépendante | Parking partagé