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