Create LocalDB for testing from Visual Studio SQL project

Question

I'm trying to create an integration tests for my project. I need to test a controller that makes call to stored procedure through repository. An empty database should be created on each runs of certain scope of tests. So I'm going to implement the following steps:

Create LocalDB
Run some Pre-scripts(to add test data)
Run test
Run some Post-scripts (if needed to run other test on this database)
Remove LocalDB

In my solution I have .sqlproj with all tables and SPs. How can I create LocalDB with the same structure as in .sqlproj from C# code? Or how can I generate the script with all objects to run it on LocalDB?

In bin folder of .sqlproj exists MyProjectName_Create.sql but it doesn't run in cmd.ExecuteNonQuery();

Any help/suggestion will be appreciated. Thanks

P.S. Related question is How to disable predeployment and postdeployment scripts in DacServices.Deploy()

do you create an empty database in MyProjectName_Create.sql ? — BobNoobGuy
– BobNoobGuy, Commented Mar 30, 2017 at 21:42

theSushil · Accepted Answer · 2017-05-19 02:28:05Z

1

In the build folder of your sqlproj you can also find [DBName].dacpac file. You can use sqlpackage.exe to deploy the dacpac to your localdb. Ben Day explains in this blog pretty nicely. You can find sqlpackage.exe in your sql server installation folder if it is not directly available from the command line.

SqlPackage /Action:Publish 
   /SourceFile:”Benday.SampleApp.Database.dacpac”
   /TargetDatabaseName:BendaySampleAppDb 
   /TargetServerName:”demo2012util”

answered May 19, 2017 at 2:28

theSushil

4807 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create LocalDB for testing from Visual Studio SQL project

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related