Coolstorage - ORM library for .NET

  •        5378

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

  • Supports SQL Server 2000/2005, MySQL, SQLite, MS Access and VistaDB. Other custom providers can be added.
  • Full support for MonoTouch (using SQLite)
  • Session-less and context-free database access
  • Any existing relational data model can be mapped to CoolStorage objects with minimal effort
  • No code generator required. Mapping is done by creating simple classes.
  • All relation types are supported: One-To-Many, Many-To-One and Many-To-Many
  • Completely typed object model (no type casts required)
  • Dirty tracking on the column level. Only changed fields are persisted to the database
  • Full support for transactions, including ##TransactionScope##
  • Nullable columns can be mapped to nullable fields or to a default value
  • Delayed (lazy) loading of data to minimize database access. Configurable per field.
  • Selective or automatic prefetching of all relation types for improved query performance
  • Powerful and intuitive database-independent object query language
  • Flexible event mechanism to intercept any event
  • Identity (auto-increment) keys or sequences are supported for all database types
  • Support for server and client generated Guid keys
  • Objects can be mapped to different databases, even across object relations
  • Paging of 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 and up, taking full advantage of generics and nullable types
  • 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 250 KB, including Vici Core)

http://viciproject.com/wiki/projects/coolstorage/home

Tags
Implementation
License
Platform

   




Related Projects

nHydrate - Conceive, Model, Generate


nHydrate is an object-relational mapping (ORM) solution for the Microsoft .NET platform providing a framework for a relational database to be mapped to .NET objects. It is designed to alleviate the software developers experience writing persistence domains. The model controls database generation, LINQ syntax, API, DAL, etc.

Database Objects - ORM in VB6


The DatabaseObjects library is an open source tool for mapping relation database systems (MySQL, SQL Server, Microsoft Access) to an object-oriented structure. The library can simplify the development and maintenance of small and large systems by providing a mechanism to consolidate business logic, maintain data integrity, increasing productivity and minimise errors.

NHibernate - object-relational mapper for .NET


NHibernate is a mature, open source object-relational mapper for the .NET framework. NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database.

Fluent NHibernate - Fluent mapping for model


Fluent, XML-less, compile safe, automated, convention-based mappings for NHibernate. Fluent NHibernate offers an alternative to NHibernate's standard XML mapping files. Rather than writing XML documents, you write mappings in strongly typed C# code. This allows for easy refactoring, improved readability and more concise code.

ActiveRecord - ActiveRecord pattern for .NET


The Castle ActiveRecord project is an implementation of the ActiveRecord pattern for .NET. The ActiveRecord pattern consists on instance properties representing a record in the database, instance methods acting on that specific record and static methods acting on all records. Castle ActiveRecord is built on top of NHibernate, but its attribute-based mapping free the developer of writing XML for database-to-object mapping, which is needed when using NHibernate directly.



SubSonic - Data access for .NET


SubSonic is A Super High-fidelity Batman Utility Belt that works up your Data Access (using Linq in 3.0), throws in some much-needed utility functions, and generally speeds along your dev cycle.

BL-Toolkit - Business Logic Toolkit for .NET


Business Logic Toolkit is a set of components to simplify .NET application development. BLToolkit is provided as source code that you can use "as is" or customize for your applications. It is written in C# and compatible with .NET Framework 3.5 and 4.0.

Doctrine ORM - Object relational mapper for PHP


Object relational mapper (ORM) for PHP that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.

Qcodo - Code Less Do More


The Qcodo Development Framework is an open-source PHP web application framework which builds an Object Relational Model (ORM), CRUD (Create, Retrieve, Update, Delete) UI pages, and AJAX hooks from an existing data model. It additionally includes a tightly-integrated HTML and JavaScript form toolkit which interfaces directly with the generated entities. It is a robust, comprehensive framework which can be utilized by small and large Web applications alike.

pdoMap - ORM for PHP


pdoMap is a PHP ORM (object-relational mapping) framework. The main aim of this project is to provide to PHP developers a RAD framework and a new way of dealing with databases.

Hibernate - Relational Persistence for Java


Hibernate facilitated the storage and retrieval of domain objects via Object/Relational Mapping. Today, Hibernate is a collection of related projects enabling developers to utilize POJO-style domain models in their applications in ways extending well beyond Object/Relational Mapping.

Outlet - object-to-relational mapping for PHP


Outlet differs from other orm solutions for php in that it provides transparent, unobtrusive persistence. It does not require your entity objects to implement any interfaces or extend some sort of base class. It is also very lightweight, only a handful of classes and tools.

RedBeanPHP - Easiest ORM layer for php


RedBeanPHP is an open source ORM (object relational mapping) tool for PHP. It focuses on simplicity and ease of use. What makes RedBean unique is that it creates your database schema on-the-fly. It scans your data and adjusts the column types to fit your object properties. If your models are stabilized you can freeze the database. This way RedBean is easy to develop with but is also extremely fast on production servers.

Propel - smart easy object persistance in PHP


Propel is an open-source Object-Relational Mapping (ORM) for PHP5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data. Propel uses PDO as an abstraction layer, and code generation to remove the burden of runtime introspection. Therefore Propel is fast.

coolstorage - Vici CoolStorage is a cross-platform .NET ORM library


Vici CoolStorage is a cross-platform .NET ORM library

dORM - Automate SQL. Focus on business logic


dORM is a PHP 5 ORM (object relational mapper) library that seamlessly loads, saves and deletes PHP objects from and to a relational database. dORM requires a small XML file that maps classes to their respective database tables. currently, only MySQL was tested.

norm - Not Object-Relational Mapping


Norm is a simple way to access a JDBC database, usually in one line of code. It purges your code of the complex mess that is Hibernate, JPA, and ORM. It is an extremely lightweight layer over JDBC. It gets rid of large amounts of boilerplate JDBC code.

OrmLite - A lightweight ORM for Java


Object Relational Mapping Lite (ORM Lite) provides some simple, lightweight functionality for persisting Java objects to SQL databases while avoiding the complexity and overhead of more standard ORM packages.

Apache Cayenne - User-friendly Java ORM with tools


Cayenne is a Java object relational mapping (ORM) framework. Cayenne seamlessly binds one or more database schemas directly to Java objects, managing atomic commit and rollbacks, SQL generation, joins, sequences, and more. With Cayenne's Remote Object Persistence, those Java objects can even be persisted out to clients via Web Services.

CoolStorage.NET


CoolStorage.NET is a fully typed Object Relational Mapping library for .NET 2.0. Advanced use of generics make this ORM library extremely intuitive to use. As of May 1st, 2009, this project has been moved to the Vici Project (www.viciproject.com)