public static void Delete(int patternId)
{
var sql = @"
DELETE FROM SocketBoxPatternColors
WHERE PatternId = " + patternId;
var db = SocketBoxPatternColor.GetDatabase();
db.ExecuteNonQuery(sql);
}
public static List <SocketBoxPatternColor> Get(int patternId)
{
var sql = @"
SELECT * FROM SocketBoxPatternColors
WHERE
PatternId = " + patternId.ToString();
var db = SocketBoxPatternColor.GetDatabase();
return(db.ExecuteQuery <SocketBoxPatternColor>(sql));
}