public static void Delete(string constructionCode) { var sql = @"DELETE FROM RimokonNiches WHERE ConstructionCode = '" + constructionCode + "'"; var db = RimokonNiche.GetDatabase(); db.ExecuteNonQuery(sql); }
public static List <RimokonNiche> Get(string constructionCode) { constructionCode = constructionCode.Replace("'", "''"); var sql = @"SELECT * FROM RimokonNiches WHERE ConstructionCode = '" + constructionCode + "'"; var db = RimokonNiche.GetDatabase(); return(db.ExecuteQuery <RimokonNiche>(sql)); }