public void Test3()
{
using (var ctx = new CodeCamperDataContext())
{
var result = ctx.TestModel.FromSql("select id, 'blah' as word from test_table").Where(t => t.Id == 1).FirstOrDefault();
}
}
public void Test2()
{
using (var ctx = new CodeCamperDataContext())
{
var result = ctx.Database.GetDbConnection().Query <TestModel>("select id, 'blah' as word from test_table where id = 1").FirstOrDefault();
}
}
public void Test4()
{
using (var ctx = new CodeCamperDataContext())
{
var query = ctx.TestModel.FromSql("select id, 'blah' as word from test_table").Where(t => t.Id == 1);
var sql = query.ToString();
}
}
public ValuesController(CodeCamperDataContext ctx)
{
this.ctx = ctx;
}
