public void Write()
{
var o = new TestObject3();
TypeAccessor.WriteConsole(o);
TypeAccessor.WriteDebug(o);
}
public void TransactionTest()
{
using (DbManager db = new DbManager())
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
db.BeginTransaction();
// Insert and get id.
//
Person person = Person.CreateInstance();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = pa.Insert(db, person);
person = pa.SelectByID(db, id);
TypeAccessor.WriteConsole(person);
Assert.IsNotNull(person);
// Update.
//
person.Gender = Gender.Other;
pa.Query.Update(db, person);
person = pa.SelectByID(db, person.ID);
TypeAccessor.WriteConsole(person);
Assert.AreEqual(Gender.Other, person.Gender);
// Delete.
//
pa.Query.Delete(db, person);
person = pa.SelectByID(db, person.ID);
Assert.IsNull(person);
db.CommitTransaction();
// Get All.
//
List <Person> list = pa.Query.SelectAll(db);
foreach (Person p in list)
{
TypeAccessor.WriteConsole(p);
}
}
}
public void ExecuteObject2Sql()
{
using (DbManager db = new DbManager())
{
DataTypeSqlTest dt = (DataTypeSqlTest)db
.SetCommand("SELECT * FROM DataTypeTest WHERE DataTypeID = " + db.DataProvider.Convert("id", ConvertType.NameToQueryParameter),
db.Parameter("id", 2))
.ExecuteObject(typeof(DataTypeSqlTest));
TypeAccessor.WriteConsole(dt);
}
}
public void ExecuteObject()
{
using (DbManager db = new DbManager())
{
Person p = (Person)db
.SetCommand("SELECT * FROM Person WHERE PersonID = " + db.DataProvider.Convert("id", ConvertType.NameToQueryParameter),
db.Parameter("id", 1))
.ExecuteObject(typeof(Person));
TypeAccessor.WriteConsole(p);
}
}
public void TestDataTypeTestInsertWithIdentity()
{
using (DbManager db = new DbManager())
{
var dt = new DataTypeTest2
{
Binary_ = new byte[2] {
1, 2
},
#if !ORACLE
Boolean_ = true,
Guid_ = Guid.Empty,
#endif
Byte_ = 250,
Bytes_ = new byte[] { 2, 1 },
DateTime_ = DateTime.Now,
Decimal_ = 9876543210.0m,
Double_ = 12345.67890,
Int16_ = 12345,
Int32_ = 1234567890,
Int64_ = 1234567890123456789,
Money_ = 99876543210.0m,
Single_ = 1234.0f,
String_ = "Crazy Frog",
Char_ = 'F',
SByte_ = 123,
UInt16_ = UInt16.MaxValue,
UInt32_ = UInt32.MaxValue,
UInt64_ = UInt64.MaxValue,
#if !SQLCE
Stream_ = new MemoryStream(5),
Xml_ = new XmlTextReader(new StringReader("<xml/>")),
XmlDoc_ = new XmlDocument()
#endif
};
#if !SQLCE
string innerxml = "<root><sql id=\"2\">Other Verbiage</sql></root>";
dt.XmlDoc_.LoadXml(innerxml);
#endif
var id = Convert.ToInt32(db.InsertWithIdentity(dt));
var obj = db.GetTable <DataTypeTest2>().Where(_ => _.ID == id).First();
#if !SQLCE
Assert.AreEqual(innerxml, obj.XmlDoc_.OuterXml);
#endif
TypeAccessor.WriteConsole(obj);
}
}
public void StreamTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
Stream s = ta.GetStream(db, 2);
Byte[] bytes = new byte[16];
Assert.IsNotNull(s);
Assert.AreEqual(s.Length, bytes.Length);
Assert.AreEqual(s.Read(bytes, 0, bytes.Length), bytes.Length);
TypeAccessor.WriteConsole(bytes);
}
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
// Insert and get id.
//
Person person = Person.CreateInstance();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = pa.Insert(person);
person = pa.SelectByID(id);
TypeAccessor.WriteConsole(person);
Assert.IsNotNull(person);
// Update.
//
person.Gender = Gender.Other;
pa.Query.Update(person);
person = pa.SelectByID(person.ID);
TypeAccessor.WriteConsole(person);
Assert.AreEqual(Gender.Other, person.Gender);
// Delete.
//
pa.Query.Delete(person);
person = pa.SelectByID(person.ID);
Assert.IsNull(person);
// Get All.
//
List <Person> list = pa.Query.SelectAll();
foreach (Person p in list)
{
TypeAccessor.WriteConsole(p);
}
}
public void Test()
{
// Insert.
//
Person person = TypeAccessor <Person> .CreateInstanceEx();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = InsertPerson(person);
person = GetPersonByID(id);
TypeAccessor.WriteConsole(person);
Assert.IsNotNull(person);
// Update.
//
person.Gender = Gender.Other;
UpdatePerson(person);
person = GetPersonByID(id);
TypeAccessor.WriteConsole(person);
Assert.AreEqual(Gender.Other, person.Gender);
// Delete.
//
DeletePerson(id);
person = GetPersonByID(id);
Assert.IsNull(person);
}
public void Sproc2()
{
Person person = GetPersonSproc2(1);
TypeAccessor.WriteConsole(person);
}
public void SqlText()
{
Person person = GetPersonSqlText(1);
TypeAccessor.WriteConsole(person);
}
