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