public void Init()
{
sqlHelper = new DapperSqlServerOperator(@"Server=DESKTOP-T36VH59;Database=Sample;uid=sa;pwd=sasa;");
sqlHelper.ExecuteNonQuery("DELETE [dbo].[Person]");
string _sql = @"INSERT INTO [dbo].[Person]
([ID]
,[UserName]
,[Address]
,[Age]
,[Password]
,[RegisterDate])
VALUES
(@ID
,@UserName
,@Address
,@Age
,@Password
,@RegisterDate)";
for (int i = 0; i < 10; i++)
{
Person _person = new Person();
_person.Address = RandomHelper.NextHexString(10);
_person.Age = (byte)i;
_person.ID = Guid.NewGuid().ToString();
_person.UserName = RandomHelper.NextHexString(10);
_person.Password = RandomHelper.NextHexString(10);
_person.RegisterDate = RandomHelper.NextDateTime();
sqlHelper.ExecuteNonQuery <Person>(_sql, _person);
}
}
public void Init()
{
sqlHelper = new DapperSqlServerOperator(@"Server=YANZHIWEI-PC\SQLEXPRESS;Database=Sample;uid=sa;pwd=sasa;");
}
public void Init()
{
string _connectString = @"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.102.2.165)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=LC)));User Id=user01;Password=Orcl_4321;";
OralceHelper = new DapperOracleOperator(_connectString);
}