SubSonic The ORM tool for .NET

Some of you might be familiar with SubSonic. I thought of writing a simple introduction to SubSonic here.

What is SubSonic ?
In simple words a tool/libraby builds the .NET data access classes instantly against the database you have mentioned in a configuration file.

It’s uses ORM ( Object Relational Mapping) mechanism to auto-magically (not a mistake, i meant auto-magic only) build data access classes for your ASP.NET web application or Win form App.

It helps in creating your database centric application faster and efficiently. SubSonic reads the structure of your database, and builds classes to provide you with a fast and flexible data access layer. It requires minimal configuration to set up, provides you with a number of different methods for retrieving and saving data, and includes methods to customize the classes to fit with your own development style. SubSonic was inspired by the ActiveRecord classes in Ruby on Rails. However, SubSonic is pure .NET and fits with the .NET methods of development.

I would suggest visiting the Subsonic home page

and an article which gives Introduction to SubSonic  by Kent Sharkey at DotNetSlakers(dot)com

After reading please tell how do you feel about it. Pretty Cool na..

Before closing this post. i thought of telling one more thing.

Why we need SubSonic, since have LINQ in .NET 3.5 onwards?

The answer is LINQ doesn’t support all data sources. But with subsonic and  LINQ together we could have a vast possibility of communicating with MYSQL, ORACLE,  DB2 and most of other data sources too..

So subsonic is a cool tool for ORM mapping in .NET 1.1 and above. Remember latest version 3.0.3, required .NET 3.5 as minimum requirements. Older versions of SubSonic will work on .NET Frameworks below 3.5’s..

Have Fun!! Happy Coding !!!

This is just an introduction. May be in future i may post more on my experiences with SubSonic..