static void Main(string[] args)
{
using (var dc = new TestDataDB("TestData"))
{
var int1 = (int?)1;
var str2 = "2";
dc.ScalarOutputParameter(ref int1, ref str2);
}
}
static void Main(string[] args)
{
using (var db = new TestDataDB())
{
var q =
from c in db.People
select c;
foreach (var c in q)
{
Console.WriteLine(c.PersonID);
}
db.Patient_SelectByName("", "");
}
}
static void Main()
{
DataConnection.TurnTraceSwitchOn();
DataConnection.WriteTraceLine = (s,s1) => Debug.WriteLine(s,s1);
using (var db = new TestDataDB())
{
try { db.DropTable<TestTable>(); } catch (Exception) {}
var table = db.CreateTable<TestTable>();
var identity = db.GetTable<TestTable>()
.InsertWithIdentity(() => new TestTable
{
Name = "Crazy Frog",
CreatedOn = Sql.CurrentTimestamp
});
Console.WriteLine(identity);
table.Drop();
}
}
static void Main()
{
DataConnection.TurnTraceSwitchOn();
DataConnection.WriteTraceLine = (s, s1) => Debug.WriteLine(s, s1);
using (var db = new TestDataDB())
{
try { db.DropTable <TestTable>(); } catch (Exception) {}
var table = db.CreateTable <TestTable>();
var identity = db.GetTable <TestTable>()
.InsertWithIdentity(() => new TestTable
{
Name = "Crazy Frog",
CreatedOn = Sql.CurrentTimestamp
});
Console.WriteLine(identity);
table.Drop();
}
}
