public string GetSaveQuery(Persistable obj, IEnumerable<Parameter> parameters) { var parameterList = parameters.ToList(); var exists = obj.ExistsInDb; var name = obj.TableDef.TableName; if (exists.HasValue) { return exists.Value ? GetUpdateStatement(name, parameterList) : GetInsertStatement(name, parameterList); } return string.Concat("IF EXISTS (SELECT 1 FROM [dbo].[", name, "] WHERE [Id]=@Id) ", GetUpdateStatement(name, parameterList), " ELSE ", GetInsertStatement(name, parameterList)); }
public string GetDeleteQuery(Persistable obj) { return string.Concat("DELETE FROM [dbo].[", obj.TableDef.TableName, "] WHERE [Id]=@Id"); }