search

oibo8x / subsonicproject

Automatically exported from code.google.com/p/subsonicproject
0 stars 0 forks source link

Seperate QueryCommands for each command in a migration #33

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Attached is a patch that changes the BuildSqlCommands method and the
BuildCommands method in Migrations.cs that will break up each SQL statement
into its own command to run separately within the transaction.  I am not
quite sure if it will help anything, but it seems like that would be the
way to run these commands. 

I don't have such an old version of MBUnit to run the tests, but I did
update the tests and they should pass :)

Let me know if you think I'm crazy of if it makes sense. It is based off
revision 480.

Original issue reported on code.google.com by tommy....@gmail.com on 13 Aug 2008 at 11:33

Attachments:

GoogleCodeExporter commented 9 years ago 
The reason they are together is to ensure SQL validation. If there's a problem 
with 
this approach let me know :)

Original comment by robcon...@gmail.com on 9 Apr 2009 at 1:01