Project DescriptionYet another .NET-oriented ready to use object-relational mapping library. The key features are Web-related (caching, integration with standard ASP.NET providers).
The project is strated in early 2004. Now it's a proved framework for large and complex data-driven projects and web
Worm
Worm is a .NET-oriented new truly object-relational mapping library which hides from the developer all SQL and pseudo-SQL statements. It supports CRUD, caching, undo, and other features.
Differencies from NHibernate. See also
Quick starts and
class reference.
Features.
Quick start
Consider the following table "Store"
taked from standard AdventureWorks database. How can we map the table with a minimum cost to access the data from code?
Well first of all you should add reference to Worm.Orm.dll and CoreFramework.dll assemblies. The next thing - create Store class.
public class Store
{
public int CustomerID { get; set; }
public string Name { get; set; }
}
As you can see it just has two properties CustomerID and Name.
Third thing you should do is to add connection string to you database. For instance
Server=.\sqlexpress;Initial Catalog=AdventureWorks;Integrated security=true;
And the final step - writing a program.
static void Main(string[] args)
{
var query = new QueryCmd(exam1sharp.Properties.Settings.Default.connString);
foreach (Store s in query
.From(new SourceFragment("Sales", "Store"))
.ToList())
{
Console.WriteLine("Store id: {0}, name: {1}", s.CustomerID, s.Name);
}
}
There is no attributes, XML files and other staff. Worm supports inline entity mapping.