public string Get()
{
using (navobjectpermissionsreportsqldatabaseContext db = new navobjectpermissionsreportsqldatabaseContext())
{
return("count: " + db.Data.Count <Data>().ToString());
}
}
public List <Data> Get(string type, long id)
{
using (navobjectpermissionsreportsqldatabaseContext db = new navobjectpermissionsreportsqldatabaseContext())
{
var filterobjecttype = "\'" + type + "\'"; //'TableData'
var filterobjectid = id;
var data = db.Data.FromSql
("SELECT * FROM DATA " +
$"WHERE objecttype = {filterobjecttype} and (({filterobjectid} >= rangefrom) AND ({filterobjectid} <= rangeto)) " +
"ORDER BY modulename, productline, versionname, dataid").ToList();
return(data);
}
}
