ADO.NET實(shí)體數(shù)據(jù)模型詳細(xì)介紹

更新時(shí)間：2012年11月16日 10:16:29 作者：

本文將詳細(xì)介紹ADO.NET實(shí)體數(shù)據(jù)模型,下面先看看簡(jiǎn)單的單表的增刪改查操作，然后再看多表的關(guān)聯(lián)查詢，帶參數(shù)查詢等

OleDbConnection，OracleConnection 或者SqlConnection這種連接，直接執(zhí)行sql語句?，F(xiàn)在的連接方式執(zhí)行sql語句有了很大的不同，下面先看看簡(jiǎn)單的單表的增刪改查操作，然后再看多表的關(guān)聯(lián)查詢，帶參數(shù)查詢等。
一、ADO.NET Entity對(duì)單表的增刪改查
有一個(gè)表，即在工程中是一個(gè)實(shí)體user，為了測(cè)試方便，所有字段為string型。

1、增加新記錄
增加一條記錄如下：

[csharp]
using (OracleEntities entities = new OracleEntities())
{
               User uer = User.CreateUser("id", "name", "age", "1");

               entities.User.AddObject(user);

               entities.SaveChanges();

using (OracleEntities entities = new OracleEntities())
{
User uer = User.CreateUser("id", "name", "age", "1");

entities.User.AddObject(user);

entities.SaveChanges();
}
2、刪除內(nèi)容

復(fù)制代碼代碼如下:

using (OracleEntities entities = new OracleEntities())
{
                User user = entities.User.First<User>(a => a.ID.Equals("id"));

                entities.DeleteObject(user);

                entities.SaveChanges();
}

using (OracleEntities entities = new OracleEntities())
{
User user = entities.User.First<User>(a => a.ID.Equals("id"));

entities.DeleteObject(user);

entities.SaveChanges();
}

3、修改內(nèi)容

復(fù)制代碼代碼如下:

using (OracleEntities entities = new OracleEntities())
{
                User user = entities.User.First<User>(a => a.User.Equals("id"));

                user.Remarks = "修改了內(nèi)容";

                entities.SaveChanges();
}

using (OracleEntities entities = new OracleEntities())
{
User user = entities.User.First<User>(a => a.User.Equals("id"));

user.Remarks = "修改了內(nèi)容";

entities.SaveChanges();
}

4、查詢內(nèi)容
（1）實(shí)體直接查詢
[/code]
using (OracleEntities entities = new OracleEntities())
{
                ObjectQuery<User> result = entities.User;//查詢所有

                foreach (User item in result)
                {

                }
}

using (OracleEntities entities = new OracleEntities())
{
ObjectQuery<User> result = entities.User;//查詢所有

foreach (User item in result)
{

}
}
[/code]
（2）Esql查詢

復(fù)制代碼代碼如下:

ObjectQuery<DbDataRecord> result = entities.CreateQuery<DbDataRecord>("select value it  from  OracleEntities.User as it ");

（3）按條件查

復(fù)制代碼代碼如下:

var result = entities.User.Where(o => o.id.Equals("id"));

二、關(guān)聯(lián)查詢
比如還有個(gè)表Other與User外鍵關(guān)聯(lián)。

進(jìn)行查詢?nèi)缦拢?BR>

復(fù)制代碼代碼如下:

using (OracleEntities entities = new OracleEntities())
{
                string esql = "SELECT b.detail FROM OracleEntities.User as a,OracleEntities.Other as b where a.otherid = b.id and a.id='id'";

                ObjectQuery<DbDataRecord> query = entities.CreateQuery<DbDataRecord>(esql);

                foreach (DbDataRecord r in query)
                {
                    string ss = r["detail"].ToString();
                }
}

using (OracleEntities entities = new OracleEntities())
{
string esql = "SELECT b.detail FROM OracleEntities.User as a,OracleEntities.Other as b where a.otherid = b.id and a.id='id'"; www.dhdzp.com

ObjectQuery<DbDataRecord> query = entities.CreateQuery<DbDataRecord>(esql);

                foreach (DbDataRecord r in query)
                {
                    string ss = r["detail"].ToString();
                }
}

當(dāng)然這些都是最基本的用法，因?yàn)槭褂玫腖inq和ESql，在后面再Linq和ESql的用法里再詳細(xì)說明。

您可能感興趣的文章: