ASP.NET 2.0 ORM library. Save/Update/Load, native SQL queries Easy to start.

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

Mon, 14 Apr 2008 15:19:23 GMT

There are no changes in the lib but I did changes in demo project.
Also Core classes are now stored in their own project (dll)
ANd added a web demo project.

...SQL Server 2005 Demo db added

Some info about attached files
* *EasyPersist.dll* -- is the compiled EasyPersist lib. If you don't want to checkout the code you can just use this dll. Copy into bin folder for websites and add a refference in Visual Studio
* *Core Demo Classes Project* -- is the "dll lib" project contains buissines classes fo the demo Site and Console Demo Projects. You don't need it if you just want to run the web or console demo it is also included in this projects as dll. But I recomend to look at it to understand the lib better.
* *Web Site Demo* -- is the main demo I guess most of people are looking for. So it consists of 2 pages one lists the cities and the otehr is edit page which allows to add/edit a city. It inclides both dlls ORM and CoreClasses dll. More info here: [Web Demo Description]
* *Console Demo Project* -- is a simple console app which shows how to work with the lib. It is very basik just a couple lines of code :). More info is here: [Console Demo Description]
* *Demo Database Bak SQL Server 2005* -- is the backup of the database with data for demo projects. It is included in other zips so no need to download it as you already have it in Console or demo zips.

UPDATED WIKI: Web Demo Description

trooper — Sat, 12 Apr 2008 08:34:33 GMT

Website Demo

I've created a simple project to show how to work with EasyPersist in the real life.
The website consists of 2 pages and allows you to view the list of cities, add a city and edit a city.

On edit page for Counties I use OpenSource project -- AJAX facebook like Autocomplete control.

also other opensource used:
Prototypejs javascript framework
AJAX Control Toolkit

How To Run

Download Web Site Demo from the Release Page
Unzip into IIS folder (usually c:\Inetpub\wwwroot\) The ZIP contains a folder with the site an SQL Struct and SQL Server 2005 DB bak. You need to restore the db backup in you SQL.
You can open website with Visual Studio and run it there or From IIS console create an application for the folder with the site files
Go to your site root\App_Code\AppConfig.cs and edit Connection string
Open the site in the browser

.....more info coming soon.... I'm ready to answer questions and provide some help ;)

download the project sources from the release page

NEW POST: General

trooper — Sat, 12 Apr 2008 07:35:21 GMT

Post your questions & suggestions here !

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

Sat, 12 Apr 2008 07:33:54 GMT

There are no changes in the lib but I did changes in demo project.
Also Core classes are now stored in their own project (dll)
ANd added a web demo project.

...SQL Server 2005 Demo db added

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

Sat, 12 Apr 2008 07:32:37 GMT

There are no changes in the lib but I did changes in demo project.
Also Core classes are now stored in their own project (dll)
ANd added a web demo project.

UPDATED WIKI: Web Demo Description

trooper — Fri, 11 Apr 2008 12:40:57 GMT

Website Demo

UPDATED WIKI: Home

trooper — Thu, 10 Apr 2008 21:18:08 GMT

EasyPersist ORM Framework Guide

Core Demo Classes Description
Console Demo Description
Web Demo Description

Quick Start Guide

EasyPersist ORM lib is used to simplify Loading and Saving objects in SQL Server. The lib uses native SQL to query db.
Core functionality includes:

Save/Update object in DB
Load objects from DB
Load lists of objects from DB
Delete object from DB

The mapping mechanism is very simple. Done via attributes (no complex xml etc.).

There are two ways to use it

Load/Save “Persistent” object in db.
Load “Read-only” object from db.

ReadOnly Classes

Used in situation when you need to quickly load custom data and don’t want to save it back in db. Very useful when you already have data layer but want to use the lib to simplify loading of objects.

So first of all you need a class to work with.

LocationHelper class is:

    using System.Data;
using Loc.HibernateMini.Attributes;
 
namespace EasyPersistDemo {
    public class TestLocation {
        private int _id;
        private string _city;
        private string _county;
        private string _state;
        
        [PersistentProperty("LocCityId", DbType.Int32)]
        public int Id {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("CityName", DbType.String)]
        public string City {
            get { return _city; }
            set { _city = value; }
        }
        [PersistentProperty("CountyName", DbType.String)]
        public string County {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("StateName", DbType.String)]
        public string State {
            get { return _state; }
            set { _state = value; }
        }
        public override string ToString()
        {
            return City + ", " + County + ", " + State;
        }
        public string CityCaps {
            get { return _city.ToUpper(); }
        }
    }
}

The lib will take this TestLocation, loop thru properties marked with PersistentProperty attribute and set their values from the dataset. Note that CityCaps property is not marked with PersistentProperty Attribute. It encapsulates some business logic and should not be bind/loaded with data. (Attribute first param is the column name in sql query)

Ok now you can load data from db

string locationSql = @"
SELECT City.CityId as LocCityId, City.Name as CityName, County.Name as CountyName, State.Name as StateName
FROM City 
INNER JOIN County ON City.CountyId=County.CountyId
INNER JOIN State ON County.StateId=State.StateId
ORDER BY City.Name, County.Name, State.Name
";
            ArrayList locations = program.Dao.GetReadOnlyListFromDb(new SqlCommand(locationSql), typeof(TestLocation));
            foreach (TestLocation location in locations)
            {
                Console.WriteLine(location.ToString());
            }

Very easy. All you need is a sql query (column names should be the same as defined in TestLocation property attributes). And call GetReadOnlyListFromDb method:

_dao.GetReadOnlyListFromDb(sqlCommand, typeof(TestLocation));

It returns a list of objects of type TestLocation.

“Persistent” classes

Persistent is the the class which is reflected by db table and could be loaded and saved in db.
“Persistent” classes are the core of your application and the data layer. Persistent class is marked with PersistentClass Attribute and implements IPersistent interface.
e.g.:

[PersistentClass("City")]
 public class City: IPersistent {

There should be an Id property required by interface

[PersistentProperty("CityId", DbType.Int32)]
public int Id {
   get { return _id; }
   set { _id = value; }
}

All properties which should be saved in db are marked with PersistentProperty attribute

using System;
using System.Data;
using Loc.HibernateMini.Attributes;
using Loc.HibernateMini.IFaces;
 
namespace EasyPersistDemo.Core {
    [PersistentClass("City")]
    public class City : IPersistent {
        //ID of the city (required to identify a record in db. usually it is identity column)
        private int _id;
        //name of the city (just a textual property)
        private string _name;
        // nullable DateTime property
        private DateTime? _changeDate; 
        //boolean property
        private bool _isActive; 
        //Enum property (maps to int in db)
        private SettlementType _type; 
        //Persistent object (many-to-one)
        private County _county; 
        
        [PersistentProperty("CityId", DbType.Int32)]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("Name", DbType.String)]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }
        [PersistentProperty("ChangeDate", DbType.DateTime)]
        public DateTime? ChangeDate
        {
            get { return _changeDate; }
            set { _changeDate = value; }
        }
        [PersistentProperty("IsActive", DbType.Boolean)]
        public bool IsActive
        {
            get { return _isActive; }
            set { _isActive = value; }
        }
        [PersistentProperty("CountyId")]
        public County County
        {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("SettlementType", DbType.Int32)]
        public SettlementType Type
        {
            get { return _type; }
            set { _type = value; }
        }
    }
    public enum SettlementType
    {
        Hamlet,Village,Town,City,Megalopolis 
    }
}

How to save a new City:

   City city = new City();
                    city.Name = "Jacksonville";
                    city.ChangeDate = DateTime.Now;
                    city.IsActive = true;
                    city.Type = SettlementType.City;
                    city.County = county;
                    _dao.SaveOrUpdate(city);
                    Console.WriteLine("Saved City " + city.Name + " ID:" + city.Id);

All you need is to create the new instance of City, set properties and call _dao.SaveOrUpdate(City);

The lib will look an Id (via IPersistent interface) and if it is 0 a new City will be created (INSERT stetement) else the lib will generate an UPDATE sql and the row will be updated.
e.g.:

INSERT INTO [City] ( [Name], [ChangeDate], [IsActive], [CountyId], [SettlementType] ) 
VALUES ( @Name, @ChangeDate, @IsActive, @CountyId, @SettlementType ); select scope_identity()

The lib prints all db calls in Debug out so you can see all db calls
e.g.:

INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
UPDATE [State] SET [Name]=@Name WHERE [State].[StateId]=2
Loading List SQL:SELECT top 1 * FROM State WHERE State.Name = @name
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
Loading List SQL:SELECT * FROM County

Note that the lib caches objects.

Use CsUnit to run tests
http://www.csUnit.org
And unitRun plug-in may be also helpful
http://www.jetbrains.com/unitrun/

Thanks.

RELEASED: EasyPersist lib and Demo Projects (Apr 11, 2008)

Thu, 10 Apr 2008 21:17:10 GMT

There are no changes in the lib but I did changes in demo project.
Also Core classes are now stored in their own project (dll)
ANd added a web demo project.

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

Thu, 10 Apr 2008 21:17:10 GMT

There are no changes in the lib but I did changes in demo project.
Also Core classes are now stored in their own project (dll)
ANd added a web demo project.

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

Thu, 10 Apr 2008 21:15:38 GMT

There are no changes in the lib but I did changes in demo project.
Also Core classes are now stored in their own project (dll)
ANd added a web demo project.

CREATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

Thu, 10 Apr 2008 21:14:07 GMT

There are no changes in the lib but I did changes in demo project.
Also Core classes are now stored in their own project (dll)
ANd added a web demo project.

UPDATED WIKI: Console Demo Description

trooper — Thu, 10 Apr 2008 21:07:33 GMT

Console Demo Project

It is just a very simple project which shows how you can use the EasyPersist lib

....more info is coming....

UPDATED WIKI: Web Demo Description

trooper — Thu, 10 Apr 2008 21:04:59 GMT

Website Demo

I've created a simple project to show how to work with EasyPersist in the real life.
The website consists of 2 pages and allows you to view the list of cities, add a city and edit a city.

On edit page I use my other OpenSource project -- AJAX facebook like Autocomplete control.

also other opensource used:
Prototypejs javascript framework
AJAX Control Toolkit

.....more info coming soon.... I'm ready to answer questions and provide some help ;)

download the project sources from the release page

UPDATED WIKI: Core Demo Classes Description

trooper — Thu, 10 Apr 2008 20:58:02 GMT

Demo Classes Project

This project contains buissines classes I use in web demo project and console demo project. (see: Console Demo Description and Web Demo Description)
The project contains of 3 classes which represent the persistent buissiness classes of the solution.

City
County
State

The structure is very simple and self-descriptive.

You can download from the release page.

UPDATED WIKI: Core Demo Classes Description

trooper — Thu, 10 Apr 2008 20:57:27 GMT

Demo Classes Project

This project contains buissines classes I use in web demo project and console demo project. (see: Console Demo Description and Core Demo Classes Description)
The project contains of 3 classes which represent the persistent buissiness classes of the solution.

City
County
State

The structure is very simple and self-descriptive.

You can download from the release page.

UPDATED WIKI: Home

trooper — Thu, 10 Apr 2008 20:50:24 GMT

EasyPersist ORM Framework Guide

Core Demo Classes Description (Load project: Core Demo Classes)
Console Demo Description (Load project: Console Demo Project)
Web Demo Description (Load project: Web Demo Project)

Quick Start Guide

EasyPersist ORM lib is used to simplify Loading and Saving objects in SQL Server. The lib uses native SQL to query db.
Core functionality includes:

Save/Update object in DB
Load objects from DB
Load lists of objects from DB
Delete object from DB

The mapping mechanism is very simple. Done via attributes (no complex xml etc.).

There are two ways to use it

Load/Save “Persistent” object in db.
Load “Read-only” object from db.

ReadOnly Classes

    using System.Data;
using Loc.HibernateMini.Attributes;
 
namespace EasyPersistDemo {
    public class TestLocation {
        private int _id;
        private string _city;
        private string _county;
        private string _state;
        
        [PersistentProperty("LocCityId", DbType.Int32)]
        public int Id {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("CityName", DbType.String)]
        public string City {
            get { return _city; }
            set { _city = value; }
        }
        [PersistentProperty("CountyName", DbType.String)]
        public string County {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("StateName", DbType.String)]
        public string State {
            get { return _state; }
            set { _state = value; }
        }
        public override string ToString()
        {
            return City + ", " + County + ", " + State;
        }
        public string CityCaps {
            get { return _city.ToUpper(); }
        }
    }
}

string locationSql = @"
SELECT City.CityId as LocCityId, City.Name as CityName, County.Name as CountyName, State.Name as StateName
FROM City 
INNER JOIN County ON City.CountyId=County.CountyId
INNER JOIN State ON County.StateId=State.StateId
ORDER BY City.Name, County.Name, State.Name
";
            ArrayList locations = program.Dao.GetReadOnlyListFromDb(new SqlCommand(locationSql), typeof(TestLocation));
            foreach (TestLocation location in locations)
            {
                Console.WriteLine(location.ToString());
            }

Very easy. All you need is a sql query (column names should be the same as defined in TestLocation property attributes). And call GetReadOnlyListFromDb method:

_dao.GetReadOnlyListFromDb(sqlCommand, typeof(TestLocation));

It returns a list of objects of type TestLocation.

“Persistent” classes

[PersistentClass("City")]
 public class City: IPersistent {

There should be an Id property required by interface

[PersistentProperty("CityId", DbType.Int32)]
public int Id {
   get { return _id; }
   set { _id = value; }
}

All properties which should be saved in db are marked with PersistentProperty attribute

using System;
using System.Data;
using Loc.HibernateMini.Attributes;
using Loc.HibernateMini.IFaces;
 
namespace EasyPersistDemo.Core {
    [PersistentClass("City")]
    public class City : IPersistent {
        //ID of the city (required to identify a record in db. usually it is identity column)
        private int _id;
        //name of the city (just a textual property)
        private string _name;
        // nullable DateTime property
        private DateTime? _changeDate; 
        //boolean property
        private bool _isActive; 
        //Enum property (maps to int in db)
        private SettlementType _type; 
        //Persistent object (many-to-one)
        private County _county; 
        
        [PersistentProperty("CityId", DbType.Int32)]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("Name", DbType.String)]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }
        [PersistentProperty("ChangeDate", DbType.DateTime)]
        public DateTime? ChangeDate
        {
            get { return _changeDate; }
            set { _changeDate = value; }
        }
        [PersistentProperty("IsActive", DbType.Boolean)]
        public bool IsActive
        {
            get { return _isActive; }
            set { _isActive = value; }
        }
        [PersistentProperty("CountyId")]
        public County County
        {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("SettlementType", DbType.Int32)]
        public SettlementType Type
        {
            get { return _type; }
            set { _type = value; }
        }
    }
    public enum SettlementType
    {
        Hamlet,Village,Town,City,Megalopolis 
    }
}

How to save a new City:

   City city = new City();
                    city.Name = "Jacksonville";
                    city.ChangeDate = DateTime.Now;
                    city.IsActive = true;
                    city.Type = SettlementType.City;
                    city.County = county;
                    _dao.SaveOrUpdate(city);
                    Console.WriteLine("Saved City " + city.Name + " ID:" + city.Id);

INSERT INTO [City] ( [Name], [ChangeDate], [IsActive], [CountyId], [SettlementType] ) 
VALUES ( @Name, @ChangeDate, @IsActive, @CountyId, @SettlementType ); select scope_identity()

The lib prints all db calls in Debug out so you can see all db calls
e.g.:

INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
UPDATE [State] SET [Name]=@Name WHERE [State].[StateId]=2
Loading List SQL:SELECT top 1 * FROM State WHERE State.Name = @name
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
Loading List SQL:SELECT * FROM County

Note that the lib caches objects.

Use CsUnit to run tests
http://www.csUnit.org
And unitRun plug-in may be also helpful
http://www.jetbrains.com/unitrun/

Thanks.

UPDATED WIKI: Home

trooper — Thu, 10 Apr 2008 20:49:34 GMT

EasyPersist ORM Framework Guide

Core Demo Classes Description (Load project: Cannot resolve link: [file:Core Demo Classes|EasyPersistWebDemo.zip])
Console Demo Description (Load project: Console Demo Project)
Web Demo Description (Load project: Cannot resolve link: [file:Web Demo Project|EasyPersistWebDemo.zip])

Quick Start Guide

EasyPersist ORM lib is used to simplify Loading and Saving objects in SQL Server. The lib uses native SQL to query db.
Core functionality includes:

Save/Update object in DB
Load objects from DB
Load lists of objects from DB
Delete object from DB

The mapping mechanism is very simple. Done via attributes (no complex xml etc.).

There are two ways to use it

Load/Save “Persistent” object in db.
Load “Read-only” object from db.

ReadOnly Classes

    using System.Data;
using Loc.HibernateMini.Attributes;
 
namespace EasyPersistDemo {
    public class TestLocation {
        private int _id;
        private string _city;
        private string _county;
        private string _state;
        
        [PersistentProperty("LocCityId", DbType.Int32)]
        public int Id {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("CityName", DbType.String)]
        public string City {
            get { return _city; }
            set { _city = value; }
        }
        [PersistentProperty("CountyName", DbType.String)]
        public string County {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("StateName", DbType.String)]
        public string State {
            get { return _state; }
            set { _state = value; }
        }
        public override string ToString()
        {
            return City + ", " + County + ", " + State;
        }
        public string CityCaps {
            get { return _city.ToUpper(); }
        }
    }
}

string locationSql = @"
SELECT City.CityId as LocCityId, City.Name as CityName, County.Name as CountyName, State.Name as StateName
FROM City 
INNER JOIN County ON City.CountyId=County.CountyId
INNER JOIN State ON County.StateId=State.StateId
ORDER BY City.Name, County.Name, State.Name
";
            ArrayList locations = program.Dao.GetReadOnlyListFromDb(new SqlCommand(locationSql), typeof(TestLocation));
            foreach (TestLocation location in locations)
            {
                Console.WriteLine(location.ToString());
            }

Very easy. All you need is a sql query (column names should be the same as defined in TestLocation property attributes). And call GetReadOnlyListFromDb method:

_dao.GetReadOnlyListFromDb(sqlCommand, typeof(TestLocation));

It returns a list of objects of type TestLocation.

“Persistent” classes

[PersistentClass("City")]
 public class City: IPersistent {

There should be an Id property required by interface

[PersistentProperty("CityId", DbType.Int32)]
public int Id {
   get { return _id; }
   set { _id = value; }
}

All properties which should be saved in db are marked with PersistentProperty attribute

using System;
using System.Data;
using Loc.HibernateMini.Attributes;
using Loc.HibernateMini.IFaces;
 
namespace EasyPersistDemo.Core {
    [PersistentClass("City")]
    public class City : IPersistent {
        //ID of the city (required to identify a record in db. usually it is identity column)
        private int _id;
        //name of the city (just a textual property)
        private string _name;
        // nullable DateTime property
        private DateTime? _changeDate; 
        //boolean property
        private bool _isActive; 
        //Enum property (maps to int in db)
        private SettlementType _type; 
        //Persistent object (many-to-one)
        private County _county; 
        
        [PersistentProperty("CityId", DbType.Int32)]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("Name", DbType.String)]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }
        [PersistentProperty("ChangeDate", DbType.DateTime)]
        public DateTime? ChangeDate
        {
            get { return _changeDate; }
            set { _changeDate = value; }
        }
        [PersistentProperty("IsActive", DbType.Boolean)]
        public bool IsActive
        {
            get { return _isActive; }
            set { _isActive = value; }
        }
        [PersistentProperty("CountyId")]
        public County County
        {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("SettlementType", DbType.Int32)]
        public SettlementType Type
        {
            get { return _type; }
            set { _type = value; }
        }
    }
    public enum SettlementType
    {
        Hamlet,Village,Town,City,Megalopolis 
    }
}

How to save a new City:

   City city = new City();
                    city.Name = "Jacksonville";
                    city.ChangeDate = DateTime.Now;
                    city.IsActive = true;
                    city.Type = SettlementType.City;
                    city.County = county;
                    _dao.SaveOrUpdate(city);
                    Console.WriteLine("Saved City " + city.Name + " ID:" + city.Id);

INSERT INTO [City] ( [Name], [ChangeDate], [IsActive], [CountyId], [SettlementType] ) 
VALUES ( @Name, @ChangeDate, @IsActive, @CountyId, @SettlementType ); select scope_identity()

The lib prints all db calls in Debug out so you can see all db calls
e.g.:

INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
UPDATE [State] SET [Name]=@Name WHERE [State].[StateId]=2
Loading List SQL:SELECT top 1 * FROM State WHERE State.Name = @name
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
Loading List SQL:SELECT * FROM County

Note that the lib caches objects.

Use CsUnit to run tests
http://www.csUnit.org
And unitRun plug-in may be also helpful
http://www.jetbrains.com/unitrun/

Thanks.

UPDATED WIKI: Home

trooper — Thu, 10 Apr 2008 20:19:28 GMT

EasyPersist ORM Framework Guide

Console Demo (Load demo project: Console Demo Project)
Web Demo (Load demo project: Cannot resolve link: [file:Console Demo Project|EasyPersistWebDemo.zip])

Quick Start Guide

EasyPersist ORM lib is used to simplify Loading and Saving objects in SQL Server. The lib uses native SQL to query db.
Core functionality includes:

Save/Update object in DB
Load objects from DB
Load lists of objects from DB
Delete object from DB

The mapping mechanism is very simple. Done via attributes (no complex xml etc.).

There are two ways to use it

Load/Save “Persistent” object in db.
Load “Read-only” object from db.

ReadOnly Classes

    using System.Data;
using Loc.HibernateMini.Attributes;
 
namespace EasyPersistDemo {
    public class TestLocation {
        private int _id;
        private string _city;
        private string _county;
        private string _state;
        
        [PersistentProperty("LocCityId", DbType.Int32)]
        public int Id {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("CityName", DbType.String)]
        public string City {
            get { return _city; }
            set { _city = value; }
        }
        [PersistentProperty("CountyName", DbType.String)]
        public string County {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("StateName", DbType.String)]
        public string State {
            get { return _state; }
            set { _state = value; }
        }
        public override string ToString()
        {
            return City + ", " + County + ", " + State;
        }
        public string CityCaps {
            get { return _city.ToUpper(); }
        }
    }
}

string locationSql = @"
SELECT City.CityId as LocCityId, City.Name as CityName, County.Name as CountyName, State.Name as StateName
FROM City 
INNER JOIN County ON City.CountyId=County.CountyId
INNER JOIN State ON County.StateId=State.StateId
ORDER BY City.Name, County.Name, State.Name
";
            ArrayList locations = program.Dao.GetReadOnlyListFromDb(new SqlCommand(locationSql), typeof(TestLocation));
            foreach (TestLocation location in locations)
            {
                Console.WriteLine(location.ToString());
            }

Very easy. All you need is a sql query (column names should be the same as defined in TestLocation property attributes). And call GetReadOnlyListFromDb method:

_dao.GetReadOnlyListFromDb(sqlCommand, typeof(TestLocation));

It returns a list of objects of type TestLocation.

“Persistent” classes

[PersistentClass("City")]
 public class City: IPersistent {

There should be an Id property required by interface

[PersistentProperty("CityId", DbType.Int32)]
public int Id {
   get { return _id; }
   set { _id = value; }
}

All properties which should be saved in db are marked with PersistentProperty attribute

using System;
using System.Data;
using Loc.HibernateMini.Attributes;
using Loc.HibernateMini.IFaces;
 
namespace EasyPersistDemo.Core {
    [PersistentClass("City")]
    public class City : IPersistent {
        //ID of the city (required to identify a record in db. usually it is identity column)
        private int _id;
        //name of the city (just a textual property)
        private string _name;
        // nullable DateTime property
        private DateTime? _changeDate; 
        //boolean property
        private bool _isActive; 
        //Enum property (maps to int in db)
        private SettlementType _type; 
        //Persistent object (many-to-one)
        private County _county; 
        
        [PersistentProperty("CityId", DbType.Int32)]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("Name", DbType.String)]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }
        [PersistentProperty("ChangeDate", DbType.DateTime)]
        public DateTime? ChangeDate
        {
            get { return _changeDate; }
            set { _changeDate = value; }
        }
        [PersistentProperty("IsActive", DbType.Boolean)]
        public bool IsActive
        {
            get { return _isActive; }
            set { _isActive = value; }
        }
        [PersistentProperty("CountyId")]
        public County County
        {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("SettlementType", DbType.Int32)]
        public SettlementType Type
        {
            get { return _type; }
            set { _type = value; }
        }
    }
    public enum SettlementType
    {
        Hamlet,Village,Town,City,Megalopolis 
    }
}

How to save a new City:

   City city = new City();
                    city.Name = "Jacksonville";
                    city.ChangeDate = DateTime.Now;
                    city.IsActive = true;
                    city.Type = SettlementType.City;
                    city.County = county;
                    _dao.SaveOrUpdate(city);
                    Console.WriteLine("Saved City " + city.Name + " ID:" + city.Id);

INSERT INTO [City] ( [Name], [ChangeDate], [IsActive], [CountyId], [SettlementType] ) 
VALUES ( @Name, @ChangeDate, @IsActive, @CountyId, @SettlementType ); select scope_identity()

The lib prints all db calls in Debug out so you can see all db calls
e.g.:

INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
UPDATE [State] SET [Name]=@Name WHERE [State].[StateId]=2
Loading List SQL:SELECT top 1 * FROM State WHERE State.Name = @name
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
Loading List SQL:SELECT * FROM County

Note that the lib caches objects.

Use CsUnit to run tests
http://www.csUnit.org
And unitRun plug-in may be also helpful
http://www.jetbrains.com/unitrun/

Thanks.

UPDATED WIKI: Home

trooper — Thu, 10 Apr 2008 20:18:28 GMT

EasyPersist ORM lib Quick Start Guide

Console Demo (Load demo project: Console Demo Project)
Web Demo (Load demo project: Cannot resolve link: [file:Console Demo Project|EasyPersistWebDemo.zip])

Quick Start Guide

EasyPersist ORM lib is used to simplify Loading and Saving objects in SQL Server. The lib uses native SQL to query db.
Core functionality includes:

Save/Update object in DB
Load objects from DB
Load lists of objects from DB
Delete object from DB

The mapping mechanism is very simple. Done via attributes (no complex xml etc.).

There are two ways to use it

Load/Save “Persistent” object in db.
Load “Read-only” object from db.

ReadOnly Classes

    using System.Data;
using Loc.HibernateMini.Attributes;
 
namespace EasyPersistDemo {
    public class TestLocation {
        private int _id;
        private string _city;
        private string _county;
        private string _state;
        
        [PersistentProperty("LocCityId", DbType.Int32)]
        public int Id {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("CityName", DbType.String)]
        public string City {
            get { return _city; }
            set { _city = value; }
        }
        [PersistentProperty("CountyName", DbType.String)]
        public string County {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("StateName", DbType.String)]
        public string State {
            get { return _state; }
            set { _state = value; }
        }
        public override string ToString()
        {
            return City + ", " + County + ", " + State;
        }
        public string CityCaps {
            get { return _city.ToUpper(); }
        }
    }
}

string locationSql = @"
SELECT City.CityId as LocCityId, City.Name as CityName, County.Name as CountyName, State.Name as StateName
FROM City 
INNER JOIN County ON City.CountyId=County.CountyId
INNER JOIN State ON County.StateId=State.StateId
ORDER BY City.Name, County.Name, State.Name
";
            ArrayList locations = program.Dao.GetReadOnlyListFromDb(new SqlCommand(locationSql), typeof(TestLocation));
            foreach (TestLocation location in locations)
            {
                Console.WriteLine(location.ToString());
            }

Very easy. All you need is a sql query (column names should be the same as defined in TestLocation property attributes). And call GetReadOnlyListFromDb method:

_dao.GetReadOnlyListFromDb(sqlCommand, typeof(TestLocation));

It returns a list of objects of type TestLocation.

“Persistent” classes

[PersistentClass("City")]
 public class City: IPersistent {

There should be an Id property required by interface

[PersistentProperty("CityId", DbType.Int32)]
public int Id {
   get { return _id; }
   set { _id = value; }
}

All properties which should be saved in db are marked with PersistentProperty attribute

using System;
using System.Data;
using Loc.HibernateMini.Attributes;
using Loc.HibernateMini.IFaces;
 
namespace EasyPersistDemo.Core {
    [PersistentClass("City")]
    public class City : IPersistent {
        //ID of the city (required to identify a record in db. usually it is identity column)
        private int _id;
        //name of the city (just a textual property)
        private string _name;
        // nullable DateTime property
        private DateTime? _changeDate; 
        //boolean property
        private bool _isActive; 
        //Enum property (maps to int in db)
        private SettlementType _type; 
        //Persistent object (many-to-one)
        private County _county; 
        
        [PersistentProperty("CityId", DbType.Int32)]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("Name", DbType.String)]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }
        [PersistentProperty("ChangeDate", DbType.DateTime)]
        public DateTime? ChangeDate
        {
            get { return _changeDate; }
            set { _changeDate = value; }
        }
        [PersistentProperty("IsActive", DbType.Boolean)]
        public bool IsActive
        {
            get { return _isActive; }
            set { _isActive = value; }
        }
        [PersistentProperty("CountyId")]
        public County County
        {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("SettlementType", DbType.Int32)]
        public SettlementType Type
        {
            get { return _type; }
            set { _type = value; }
        }
    }
    public enum SettlementType
    {
        Hamlet,Village,Town,City,Megalopolis 
    }
}

How to save a new City:

   City city = new City();
                    city.Name = "Jacksonville";
                    city.ChangeDate = DateTime.Now;
                    city.IsActive = true;
                    city.Type = SettlementType.City;
                    city.County = county;
                    _dao.SaveOrUpdate(city);
                    Console.WriteLine("Saved City " + city.Name + " ID:" + city.Id);

INSERT INTO [City] ( [Name], [ChangeDate], [IsActive], [CountyId], [SettlementType] ) 
VALUES ( @Name, @ChangeDate, @IsActive, @CountyId, @SettlementType ); select scope_identity()

The lib prints all db calls in Debug out so you can see all db calls
e.g.:

INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
UPDATE [State] SET [Name]=@Name WHERE [State].[StateId]=2
Loading List SQL:SELECT top 1 * FROM State WHERE State.Name = @name
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
Loading List SQL:SELECT * FROM County

Note that the lib caches objects.

Use CsUnit to run tests
http://www.csUnit.org
And unitRun plug-in may be also helpful
http://www.jetbrains.com/unitrun/

Thanks.

UPDATED WIKI: Home

trooper — Thu, 10 Apr 2008 20:17:22 GMT

EasyPersist ORM lib Quick Start Guide

Load demo project:
Demo Project

Console Demo
Web Demo

Quick Start Guide

EasyPersist ORM lib is used to simplify Loading and Saving objects in SQL Server. The lib uses native SQL to query db.
Core functionality includes:

Save/Update object in DB
Load objects from DB
Load lists of objects from DB
Delete object from DB

The mapping mechanism is very simple. Done via attributes (no complex xml etc.).

There are two ways to use it

Load/Save “Persistent” object in db.
Load “Read-only” object from db.

ReadOnly Classes

    using System.Data;
using Loc.HibernateMini.Attributes;
 
namespace EasyPersistDemo {
    public class TestLocation {
        private int _id;
        private string _city;
        private string _county;
        private string _state;
        
        [PersistentProperty("LocCityId", DbType.Int32)]
        public int Id {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("CityName", DbType.String)]
        public string City {
            get { return _city; }
            set { _city = value; }
        }
        [PersistentProperty("CountyName", DbType.String)]
        public string County {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("StateName", DbType.String)]
        public string State {
            get { return _state; }
            set { _state = value; }
        }
        public override string ToString()
        {
            return City + ", " + County + ", " + State;
        }
        public string CityCaps {
            get { return _city.ToUpper(); }
        }
    }
}

string locationSql = @"
SELECT City.CityId as LocCityId, City.Name as CityName, County.Name as CountyName, State.Name as StateName
FROM City 
INNER JOIN County ON City.CountyId=County.CountyId
INNER JOIN State ON County.StateId=State.StateId
ORDER BY City.Name, County.Name, State.Name
";
            ArrayList locations = program.Dao.GetReadOnlyListFromDb(new SqlCommand(locationSql), typeof(TestLocation));
            foreach (TestLocation location in locations)
            {
                Console.WriteLine(location.ToString());
            }

Very easy. All you need is a sql query (column names should be the same as defined in TestLocation property attributes). And call GetReadOnlyListFromDb method:

_dao.GetReadOnlyListFromDb(sqlCommand, typeof(TestLocation));

It returns a list of objects of type TestLocation.

“Persistent” classes

[PersistentClass("City")]
 public class City: IPersistent {

There should be an Id property required by interface

[PersistentProperty("CityId", DbType.Int32)]
public int Id {
   get { return _id; }
   set { _id = value; }
}

All properties which should be saved in db are marked with PersistentProperty attribute

using System;
using System.Data;
using Loc.HibernateMini.Attributes;
using Loc.HibernateMini.IFaces;
 
namespace EasyPersistDemo.Core {
    [PersistentClass("City")]
    public class City : IPersistent {
        //ID of the city (required to identify a record in db. usually it is identity column)
        private int _id;
        //name of the city (just a textual property)
        private string _name;
        // nullable DateTime property
        private DateTime? _changeDate; 
        //boolean property
        private bool _isActive; 
        //Enum property (maps to int in db)
        private SettlementType _type; 
        //Persistent object (many-to-one)
        private County _county; 
        
        [PersistentProperty("CityId", DbType.Int32)]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }
        [PersistentProperty("Name", DbType.String)]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }
        [PersistentProperty("ChangeDate", DbType.DateTime)]
        public DateTime? ChangeDate
        {
            get { return _changeDate; }
            set { _changeDate = value; }
        }
        [PersistentProperty("IsActive", DbType.Boolean)]
        public bool IsActive
        {
            get { return _isActive; }
            set { _isActive = value; }
        }
        [PersistentProperty("CountyId")]
        public County County
        {
            get { return _county; }
            set { _county = value; }
        }
        [PersistentProperty("SettlementType", DbType.Int32)]
        public SettlementType Type
        {
            get { return _type; }
            set { _type = value; }
        }
    }
    public enum SettlementType
    {
        Hamlet,Village,Town,City,Megalopolis 
    }
}

How to save a new City:

   City city = new City();
                    city.Name = "Jacksonville";
                    city.ChangeDate = DateTime.Now;
                    city.IsActive = true;
                    city.Type = SettlementType.City;
                    city.County = county;
                    _dao.SaveOrUpdate(city);
                    Console.WriteLine("Saved City " + city.Name + " ID:" + city.Id);

INSERT INTO [City] ( [Name], [ChangeDate], [IsActive], [CountyId], [SettlementType] ) 
VALUES ( @Name, @ChangeDate, @IsActive, @CountyId, @SettlementType ); select scope_identity()

The lib prints all db calls in Debug out so you can see all db calls
e.g.:

INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
INSERT INTO [State] ( [Name] ) VALUES ( @Name ); select scope_identity()
UPDATE [State] SET [Name]=@Name WHERE [State].[StateId]=2
Loading List SQL:SELECT top 1 * FROM State WHERE State.Name = @name
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
INSERT INTO [County] ( [Name], [StateId] ) VALUES ( @Name, @StateId ); select scope_identity()
Loading List SQL:SELECT * FROM County

Note that the lib caches objects.

Use CsUnit to run tests
http://www.csUnit.org
And unitRun plug-in may be also helpful
http://www.jetbrains.com/unitrun/

Thanks.

ASP.NET 2.0 ORM library. Save/Update/Load, native SQL queries Easy to start.

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

UPDATED WIKI: Web Demo Description

Website Demo

How To Run

NEW POST: General

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

UPDATED WIKI: Web Demo Description

Website Demo

UPDATED WIKI: Home

EasyPersist ORM Framework Guide

Contents

Quick Start Guide

ReadOnly Classes

“Persistent” classes

RELEASED: EasyPersist lib and Demo Projects (Apr 11, 2008)

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

UPDATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

CREATED RELEASE: EasyPersist lib and Demo Projects (апр 11, 2008)

UPDATED WIKI: Console Demo Description

Console Demo Project

UPDATED WIKI: Web Demo Description

Website Demo

UPDATED WIKI: Core Demo Classes Description

Demo Classes Project

UPDATED WIKI: Core Demo Classes Description

Demo Classes Project

UPDATED WIKI: Home

EasyPersist ORM Framework Guide

Contents

Quick Start Guide

ReadOnly Classes

“Persistent” classes

UPDATED WIKI: Home

EasyPersist ORM Framework Guide

Contents

Quick Start Guide

ReadOnly Classes

“Persistent” classes

UPDATED WIKI: Home

EasyPersist ORM Framework Guide

Contents

Quick Start Guide

ReadOnly Classes

“Persistent” classes

UPDATED WIKI: Home

EasyPersist ORM lib Quick Start Guide

Contents

Quick Start Guide

ReadOnly Classes

“Persistent” classes

UPDATED WIKI: Home

EasyPersist ORM lib Quick Start Guide

Contents

Quick Start Guide

ReadOnly Classes

“Persistent” classes