public void should_query_access_database()
{
using (var query = new JetQuery(Path))
{
var widgets = query.Table<WidgetData>().ToList();
widgets[0].Id.ShouldEqual(1);
widgets[0].Name.ShouldEqual("foo");
widgets[0].Length.ShouldEqual(3.14159);
widgets[0].CreatedOn.ShouldEqual(new DateTime(1985, 10, 5));
widgets[0].Value[0].ShouldEqual(4);
widgets[0].Value[1].ShouldEqual(2);
widgets[0].Value[2].ShouldEqual(9);
widgets[1].Id.ShouldEqual(2);
widgets[1].Name.ShouldEqual("bar");
widgets[1].Length.ShouldEqual(6.22);
widgets[1].CreatedOn.ShouldEqual(new DateTime(2000, 1, 1));
widgets[1].Value[0].ShouldEqual(3);
widgets[1].Value[1].ShouldEqual(7);
widgets[1].Value[2].ShouldEqual(6);
}
}
public ArbinData(string path)
{
_query = new JetQuery(path);
}
