CoolStorage.NET

Updated Wiki: Home

activa — Sat, 09 May 2009 09:20:16 GMT

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

Commented Issue: MySQL - Using single quote in text search produces expression error

activa — Fri, 28 Nov 2008 20:08:58 GMT

Error in expression. [timothy] is not a valid field name

Search term was "timothy's". Before the search was submitted, I replace single quotes ' with two single quotes ''
I also got the error when replacing single quotes ' with escaped single quotes \'
The SQL query works with '' or \'
Comments: ** Comment from web user: activa **

This is closed because it's not an issue. It's how MySQL works. From what I can tell, it has nothing to do with CoolStorage.NET

Commented Issue: MySQL - Using single quote in text search produces expression error

veector — Wed, 26 Nov 2008 18:09:09 GMT

why was this closed?

Closed Issue: MySQL - Using single quote in text search produces expression error

activa — Sun, 09 Nov 2008 22:54:21 GMT

Commented Issue: MySQL - Using single quote in text search produces expression error

veector — Wed, 05 Nov 2008 20:26:06 GMT

This MySQL syntax works: SELECT * FROM REVIEWS WHERE Comments LIKE '%Timothy\'s%'

Commented Issue: MySQL - Using single quote in text search produces expression error

veector — Wed, 05 Nov 2008 20:23:33 GMT

In VisualStudio debug, when you move your mouse over the value of SearchTerm, it will show "Timothy\\'s"

So it's sending to the database a string which already has the \ escaped.

Commented Issue: MySQL - Using single quote in text search produces expression error

veector — Wed, 05 Nov 2008 20:21:38 GMT

Ok, I confirmed that MySQL is expecting \' to escape a ' (single quote), that's why I use the first line. In the actual code the string "Timothy's" comes from a textbox.

string SearchTerm = "Timothy's".Replace("'", "\\'");
myReviewList = Review.List("Comments like '%" + SearchTerm + "%'");

Created Issue: Insert statement and read-only properties

BjornB — Tue, 04 Nov 2008 10:38:17 GMT

If you define a property in the mapping class as read-only by creating only its getter it will discard the data when inserting a new item in the database. The data of the property will be NULL in the insert statement.

ex.
public string Name { get; set; }
public int TypeId { get; }

will result in

INSERT INTO TestTable(Name, TypeId) VALUES ('Tester', NULL)

Commented Issue: Using OrderedBy with Range (descending) on CSList has error in SQL syntax

activa — Mon, 03 Nov 2008 19:25:29 GMT

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESClimit 7' at line 1

myReviewList = Review.List().Range(Convert.ToInt16(hidPageOffset.Value) + 1, Convert.ToInt16(hidNumberOfRows.Value)).OrderedBy("ReviewDate-");
Comments: ** Comment from web user: activa **

You're right. This is a problem, but it should have been fixed in the latest source code commit

Commented Issue: MySQL - Using single quote in text search produces expression error

activa — Mon, 03 Nov 2008 19:23:17 GMT

Can you show a code sample that fails?

Created Issue: MySQL - Using single quote in text search produces expression error

veector — Fri, 31 Oct 2008 20:54:32 GMT

Commented Issue: Using OrderedBy with Range (descending) on CSList has error in SQL syntax

veector — Fri, 31 Oct 2008 20:49:02 GMT

Sorry, should have clarified. Using MySQL with the latest version of the dll.

Created Issue: Using OrderedBy with Range (descending) on CSList has error in SQL syntax

veector — Fri, 31 Oct 2008 20:35:39 GMT

Source code checked in, #20944

activa — Sun, 27 Jul 2008 10:32:48 GMT

Build 287

Source code checked in, #20910

activa — Sat, 26 Jul 2008 13:08:16 GMT

Build 286

New Post: missing files in release

activa — Fri, 25 Jul 2008 08:57:44 GMT

You are right. It has been fixed...

Released: CoolStorage.NET v1.2.0 (May 29, 2008)

Fri, 25 Jul 2008 08:56:50 GMT

Changes since v1.1.2:

Support for prefetching of many-to-one, one-to-one and one-to-many relations (marked by the [Prefetch] attribute at compile-time or by using the .WithPrefetch() method). This change results in a spectacular performance improvement in most cases where lists of objects with related objects are retrieved from the database.
Support for paging at server level. Use the Range() method on the CSList class to get a specific range of records
Support for GUID fields (server-generated and client-generated)
Support for specifying a context when calling generic CSDatabase.RunQuery() methods
New method ToList<T> on CSList
New method ThenBy() on CSList (in line with the LINQ methods)
New attribute [ClientGenerated] for GUID fields
New attribute [NotMapped] for fields that are not mapped to a database column
Support for VistaDB 3.x database

Updated Release: CoolStorage.NET v1.2.0 (May 29, 2008)

Fri, 25 Jul 2008 08:56:50 GMT

Changes since v1.1.2:

Support for prefetching of many-to-one, one-to-one and one-to-many relations (marked by the [Prefetch] attribute at compile-time or by using the .WithPrefetch() method). This change results in a spectacular performance improvement in most cases where lists of objects with related objects are retrieved from the database.
Support for paging at server level. Use the Range() method on the CSList class to get a specific range of records
Support for GUID fields (server-generated and client-generated)
Support for specifying a context when calling generic CSDatabase.RunQuery() methods
New method ToList<T> on CSList
New method ThenBy() on CSList (in line with the LINQ methods)
New attribute [ClientGenerated] for GUID fields
New attribute [NotMapped] for fields that are not mapped to a database column
Support for VistaDB 3.x database

New Post: missing files in release

netsu — Fri, 25 Jul 2008 07:18:19 GMT

I did not find an easy way to contact the CoolStorage.NET owner(s) to notify this issue:

The CoolStorage.SqlServer.1.2.0.283.bin.zip only has a pdb file in it.

Source code checked in, #18604

activa — Tue, 10 Jun 2008 19:25:02 GMT

Build 285