Which free ORM tools supports SQL Server 2000 database? -
in project want use orm tool, database runs on sql server 2000. can't use entity framework , linq. can use ado.net. want know orm tools support needs?
thanks in advance.
telerik data access (free)
introducing telerik data access
how to: create domain model based on ms sql 2000 database

using system.linq; using openaccessmodel; namespace consumerproject { class program { static void main(string[] args) { using (entitiesmodel dbcontext = new entitiesmodel()) { // add new category. category newcategory = new category(); newcategory.categoryname = "new category"; dbcontext.add(newcategory); // first category using linq , modify it. category firstcategory = dbcontext.categories.firstordefault(); firstcategory.categoryname = firstcategory.categoryname + "_updated"; // commit changes database. dbcontext.savechanges(); // use linq retrieve category name 'new category'. category categorytodelete = (from c in dbcontext.categories c.categoryname == "new category" select c).firstordefault(); // delete 'new category'from database. dbcontext.delete(categorytodelete); // commit changes database. dbcontext.savechanges(); } } } } yes! linq support ms sql 2000 database
Comments
Post a Comment