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

consuming model - crud

crud operations - overview

enter image description here

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

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

android - Keyboard hides my half of edit-text and button below it even in scroll view -

css - Make div keyboard-scrollable in jQuery Mobile? -