Support For Stored Proc's

Developer
Mar 28, 2008 at 10:14 AM
Hello

Sorry for hammering the discussion forum a little here, trying to generate some discussion across the team and any users of the framework.

One of things I need is support for stored proc's, now we have a problem here as stored proc's don't really fit into the bill of c# code, so it maybe a good time to execute normal .sql files.

So Something along the lines of

public void up(DbProvider db)
{
db.ExecuteSql("/path/tofile_1.sql");
}

public void down(DbProvider db)
{
db.DropStoredProc("StoredProcName")
db.ExecureSql("/path/toPreviousVersionOfStoredProc.sql");
}

Something similar to this could also be used for views, unless anyone else has any brighter idea's on how to handle these very sql specific tasks.

Cheers

Andy