public static void Add(SqlScript script)
{
using (var q = new SqlStatement("INSERT INTO RevisionLog (name) VALUES (@name)"))
{
q.AddParameter("@name", script.Name);
q.ExecuteNonQuery();
}
}
public static bool ContainsRevision(SqlScript script)
{
CreateRevisionLogTable();
using (var q = new SqlStatement("SELECT COUNT(*) FROM RevisionLog WHERE name=@name"))
{
q.AddParameter("@name", script.Name);
return((int)q.ExecuteScalar() > 0);
}
}