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(); }