NOTE: This project has been moved to the Vici Project. The CodePlex pages will no longer by updated

CoolStorage.NET is a fully typed Object Relational Mapping library for .NET 2.0.

Although the feature list you find below is extensive, the main strength of CoolStorage.NET is the ease of use. Most ORM tools still require a lot of type casting and other plumbing to be written, CoolStorage.NET is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

The main features are:
  • Supports SQL Server 2000/2005, MySQL, IBM DB2, SQLite, MS Access, VistaDB
  • Any existing relational data model can be mapped to CoolStorage objects with minimal effort
  • All relation types are supported: One-To-One, One-To-Many, Many-To-One and Many-To-Many
  • Completely typed object model (no type casts required)
  • Full support for transactions, including .NET 2.0 TransactionScope
  • Nullable columns can be mapped to .NET 2.0 nullable fields or any other value
  • Delayed (lazy) loading of data to minimize database access
  • Selective pre-fetching of all relation types for improved query performance
  • Powerful and intuitive database-independent object query language
  • Flexible event framework to intercept any event
  • Identity (auto-increment) keys are supported for all database types
  • Support for server and client generated Guid keys
  • Sessionless data access
  • Objects can be mapped to different databases, even across object relations
  • Pageable object collections (at server level)
  • Extensive support for retrieving aggregate values on collections (count, sum, average, ...)
  • Collections implement IBindingList so they can be used by controls (grids) as a data source
  • Underlying database engine uses optimized and parameterized SQL queries. SQL injection is impossible
  • Built specifically for .NET 2.0, taking full advantage of generics and nullable variables
  • Raw SQL and/or stored procedures can be called on the underlying database without the need for a separate database connection
  • Small footprint (less than 120 KB)

Forum

A discussion forum dedicated to CoolStorage.NET can be found at www.forum.activa.be

Last edited May 9, 2009 at 10:20 AM by activa, version 15