public void TestInitialize()
{
//var xmlMapping = XmlMappingSource.FromStream(typeof(SQLiteTest).Assembly.GetManifestResourceStream("Test.Northwind.Access.map"));
//db = new AccessNorthwind("C:/Northwind.mdb");
//db = new AccessNorthwind("C:/Northwind.mdb", xmlMapping);
db = new SQLiteNorthwind("C:/Northwind.db3");
db.Log = Console.Out;
employees = db.GetTable <Employee>();
products = db.GetTable <Product>();
}
public void Select3()
{
var table = db.GetTable <Employee>();
table.Select(o => new { FirstName = o["FirstName"], LastName = o["LastName"] }).ToArray();
table.Select("['FirstName'] as FirstName, ['LastName'] as LastName").Cast <object>().ToArray();
table.Select("['FirstName'], ['LastName']").Cast <object>().ToArray();
table.Select("[FirstName], [LastName]").Cast <object>().ToArray();
}
public void SelectNewWithSingleProperty()
{
employees.Select("new ([FirstName] as F)").Cast <object>().ToArray();
employees.Select("[FirstName] as F").Cast <object>().ToArray();
employees.Select("new ([FirstName])").Cast <object>().ToArray();
var table = db.GetTable <Employee>();
table.Select(o => new { F = o.FirstName }).ToArray();
table.Select("new (FirstName as F)").Cast <object>().ToArray();
table.Select("FirstName as F").Cast <object>().ToArray();
}