Dapper. Execute Query with GOs

user_577805 0
Viewed 3587

I am trying to use Dapper to run a SQL Query:

use master
go

if exists (select name from sys.databases where name = N'TestDB')
drop database [TestDB]
go

create database [TestDB] on primary ( 
  name = 'TestDB_Data',
  filename = '$Path\TestDB_Data.mdf',
  size = 40MB,
  maxsize = 2GB,
  filegrowth = 20MB 
)

use [TestDB]
go

create table dbo.Posts
(
  Id int identity not null,
  Body nvarchar (max) null
);

I am using Dapper as follows:

using (SqlConnection connection = new SqlConnection(connectionString)) {
  connection.Open();
  connection.Execute(sqlQuery);
}

However, I get an error when using GO.

But if I remove the GO statements I get an error when creating Posts because the table TestDB wasn't created.

Is there a way to use Dapper to solve this?

I was able to do this only using SQL Server SDK.

dapper sql
3 Answers

I solved separating the executions

 using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            foreach (var item in sqlQuery.Split("GO"))
            {
                conn.Execute(item);
            }
        }
user_17578750
Related