I have been instructed to support a bunch of legacy applications using heavy stored procedures created before '05, when there was no ORM. The developers who work with me do not know Entity Framework and LINQ and do not want to learn.
Is there an ORM in .NET that provides a simple object interface to existing database tables and possibly stored procedures?
I am very pleased if it allows me to encode multiple rows to get a class for each table, and it has properties corresponding to the data in each column, as well as some methods or properties for resolving a foreign key / many-to-many relationship - go ahead and back.
For example, saving employee and department records
Employee e = new Employee("John", null);
Department d = new Department("QA");
d.save();
e.department = d;
e.save();
without writing SQL INSERT statements.
EDIT:
MS SQL Server 2008