mysql datareader dataset_C# 之 DataReader 和 DataSet 的区别

//未式关闭连接

public SysFunction GetModelById(stringid)

{

SqlConnection conn= new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConStr"].ToString());

conn.Open();

SqlCommand cmd= new SqlCommand("SELECT * FROM SysFunction WHERE FunctionId =" +id, conn);

SqlDataReader dataReader=cmd.ExecuteReader();

SysFunction model= newSysFunction();while(dataReader.Read())

{

model.FunctionName= dataReader["FunctionName"].ToString();

model.FunctionCode= dataReader["FunctionCode"].ToString();

}

dataReader.Close();

dataReader.Dispose();string drState = dataReader.IsClosed.ToString(); //True

string connState = conn.State.ToString(); //Open

returnmodel;

}//调用Connection 对象的 Close() 方法显式关闭连接

public SysFunction GetModelById(stringid)

{

SqlConnection conn= new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConStr"].ToString());

conn.Open();

SqlCommand cmd= new SqlCommand("SELECT * FROM SysFunction WHERE FunctionId =" +id, conn);

SqlDataReader dataReader=cmd.ExecuteReader();

SysFunction model= newSysFunction();while(dataReader.Read())

{

model.FunctionName= dataReader["FunctionName"].ToString();

model.FunctionCode= dataReader["FunctionCode"].ToString();

}

dataReader.Close();

dataReader.Dispose();

conn.Close();//显式关闭连接

string drState = dataReader.IsClosed.ToString(); //True

string connState = conn.State.ToString(); //Close

returnmodel;

}//调用Command 对象的 ExecuteReader() 方法时传递 CommandBehavior.CloseConnection 参数

public SysFunction GetModelById(stringid)

{

SqlConnection conn= new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConStr"].ToString());

conn.Open();

SqlCommand cmd= new SqlCommand("SELECT * FROM SysFunction WHERE FunctionId =" +id, conn);//执行该cmd时，如果关闭关联的 DataReader 对象，则关联的 Connection 对象也将关闭

SqlDataReader dataReader =cmd.ExecuteReader(CommandBehavior.CloseConnection);

SysFunction model= newSysFunction();while(dataReader.Read())

{

model.FunctionName= dataReader["FunctionName"].ToString();

model.FunctionCode= dataReader["FunctionCode"].ToString();

}

dataReader.Close();

dataReader.Dispose();string drState = dataReader.IsClosed.ToString(); //True

string connState = conn.State.ToString(); //Close

returnmodel;

}