private EntityCollection <OracleTableList> GetTableListByName(string name, string strCon1)
{
DBHelperBase <OracleTableList> helper = new DBHelperBase <OracleTableList>(DataBaseType.Oracle9i, strCon1);
OracleTableList searchCondition = helper.CreateSimpleSeachCondition();
searchCondition.Owner = name;
EntityCollection <OracleTableList> tableList1 = helper.SelectDataByCondition(searchCondition, false);//用条件查询
return(tableList1);
}
public RoleRepository(DBHelperBase dbHelper)
{
_dbHelper = dbHelper;
}
public DbRepository()
{
DBHelper = CreateDbService();
}
static void Main(string[] args)
{
Stopwatch watch = new Stopwatch();
string strconn = "Data Source=(local);Integrated Security=SSPI;Initial Catalog=ShareLocation";
//string oraclestrconn = "User ID=system;Data Source=orcl;Password=123asd";
//DBHelperBase<T_User> helper = new DBHelperBase<T_User>(DataBaseType.Oracle, oraclestrconn);
//oracleHelper.SelectAll(false);
//dataadapt 批量更新速度慢
//DataTable dt=new DataTable ();
//SqlConnection conn = new SqlConnection(strconn);
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = new SqlCommand("select * from T_USERS", conn);
//da.Fill(dt);
//foreach (DataRow dr in dt.Rows)
//{
// dr["DisplayName"] = 1;
//}
//SqlCommand updateCommand = new SqlCommand();
//updateCommand.CommandText = "Update T_USERS set DisplayName=@DisplayName where id=@id";
//updateCommand.Connection = conn;
//SqlParameter param = new SqlParameter();
//param.ParameterName = "@DisplayName";
//param.SourceColumn = "DisplayName";
//updateCommand.Parameters.Add(param);
//param = new SqlParameter();
//param.ParameterName = "@id";
//param.SourceColumn = "id";
//updateCommand.Parameters.Add(param);
//da.UpdateCommand = updateCommand;
//watch.Start();
//int i= da.Update(dt);
//watch.Stop();
//Console.WriteLine("update" + i.ToString() + "条的时间：" + watch.ElapsedMilliseconds);
//Console.Read();
//查询全部
DBHelperBase<T_User> helper = new DBHelperBase<T_User>(DataBaseType.MSSQLServer, strconn);
/*
watch.Start();
EntityCollection<T_User> users = helper.SelectAll(true);
watch.Stop();
Console.WriteLine("orm查询用aop" + users.Count+"条的时间："+ watch.ElapsedMilliseconds);
watch.Restart();
EntityCollection<T_User> users1 = helper.SelectAll(false);
watch.Stop();
Console.WriteLine("orm查询不用aop" + users.Count + "条的时间：" + watch.ElapsedMilliseconds);
//foreach (T_User aa in users)
//{
// aa.DisplayName = aa.DisplayName + Guid.NewGuid().ToString();
//}
//Console.WriteLine("开始更新");
//watch.Restart();
//users.Update();
//watch.Stop();
//Console.WriteLine("更新时间：" + watch.ElapsedMilliseconds);
//Console.Read();
string id = Guid.NewGuid().ToString();
//insert
T_User newUser = users.CreateNewEntity();
newUser.ID = id;
newUser.Password = Guid.NewGuid().ToString();
newUser.UserName = Guid.NewGuid().ToString();
newUser.State = 100;
users.Add(newUser);
users.Update();
//update
T_User user = users.Where(t => t.ID == id).First();
user.UserName = id;
users.Update();
//delete
users.Delete(user);
users.Update();
//search by condition
T_User searchuser = helper.CreateSimpleSeachCondition();
searchuser.ID = id ;
users = helper.SelectDataByCondition(searchuser,true);
*/
DbSearchConditionCollection<T_User> cc = helper.CreateComplexSeachCondition();
cc.Add(p => p.ID, DbSearchOperation.equals, "000073cd-17e3-483d-a14f-5e1efff93cb6");
EntityCollection<T_User> usersaaaa= helper.SelectDataByCondition(cc, true);
Console.Read();
}
public UserRepository(DBHelperBase dbHelper)
{
_dbHelper = dbHelper;
}
static void Main(string[] args)
{
Stopwatch watch = new Stopwatch();
string strconn = "Data Source=(local);Integrated Security=SSPI;Initial Catalog=ShareLocation";
//string oraclestrconn = "User ID=system;Data Source=orcl;Password=123asd";
//DBHelperBase<T_User> helper = new DBHelperBase<T_User>(DataBaseType.Oracle, oraclestrconn);
//oracleHelper.SelectAll(false);
//dataadapt 批量更新速度慢
//DataTable dt=new DataTable ();
//SqlConnection conn = new SqlConnection(strconn);
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = new SqlCommand("select * from T_USERS", conn);
//da.Fill(dt);
//foreach (DataRow dr in dt.Rows)
//{
// dr["DisplayName"] = 1;
//}
//SqlCommand updateCommand = new SqlCommand();
//updateCommand.CommandText = "Update T_USERS set DisplayName=@DisplayName where id=@id";
//updateCommand.Connection = conn;
//SqlParameter param = new SqlParameter();
//param.ParameterName = "@DisplayName";
//param.SourceColumn = "DisplayName";
//updateCommand.Parameters.Add(param);
//param = new SqlParameter();
//param.ParameterName = "@id";
//param.SourceColumn = "id";
//updateCommand.Parameters.Add(param);
//da.UpdateCommand = updateCommand;
//watch.Start();
//int i= da.Update(dt);
//watch.Stop();
//Console.WriteLine("update" + i.ToString() + "条的时间：" + watch.ElapsedMilliseconds);
//Console.Read();
//查询全部
DBHelperBase <T_User> helper = new DBHelperBase <T_User>(DataBaseType.MSSQLServer, strconn);
/*
*
*
* watch.Start();
* EntityCollection<T_User> users = helper.SelectAll(true);
* watch.Stop();
* Console.WriteLine("orm查询用aop" + users.Count+"条的时间："+ watch.ElapsedMilliseconds);
* watch.Restart();
* EntityCollection<T_User> users1 = helper.SelectAll(false);
* watch.Stop();
* Console.WriteLine("orm查询不用aop" + users.Count + "条的时间：" + watch.ElapsedMilliseconds);
*
*
* //foreach (T_User aa in users)
* //{
* // aa.DisplayName = aa.DisplayName + Guid.NewGuid().ToString();
* //}
* //Console.WriteLine("开始更新");
* //watch.Restart();
* //users.Update();
* //watch.Stop();
* //Console.WriteLine("更新时间：" + watch.ElapsedMilliseconds);
* //Console.Read();
*
*
*
* string id = Guid.NewGuid().ToString();
*
* //insert
*
* T_User newUser = users.CreateNewEntity();
* newUser.ID = id;
* newUser.Password = Guid.NewGuid().ToString();
* newUser.UserName = Guid.NewGuid().ToString();
* newUser.State = 100;
* users.Add(newUser);
* users.Update();
*
*
* //update
* T_User user = users.Where(t => t.ID == id).First();
* user.UserName = id;
* users.Update();
*
* //delete
* users.Delete(user);
* users.Update();
*
* //search by condition
* T_User searchuser = helper.CreateSimpleSeachCondition();
* searchuser.ID = id ;
* users = helper.SelectDataByCondition(searchuser,true);
*
*/
DbSearchConditionCollection <T_User> cc = helper.CreateComplexSeachCondition();
cc.Add(p => p.ID, DbSearchOperation.equals, "000073cd-17e3-483d-a14f-5e1efff93cb6");
EntityCollection <T_User> usersaaaa = helper.SelectDataByCondition(cc, true);
Console.Read();
}
