Run Sql Script File With Passing database name from C#

Question

I have a SQL Script File Which contains database creation, its related tables creation and other things. The database name is decided from client side. So is there any way that I can run that script file where Database name is passed from my code?

I know a way where i take some special pattern in place of database name and then in c# code I do replace it with client side added Database name. But is there any better way to do it?

you can load the text from the file, and even edit the file as Create database {0} so that it will be easy when you impport — Sandip Bantawa
– Sandip Bantawa, Commented Jun 26, 2014 at 9:00

CodingDefined · Accepted Answer · 2014-06-26 08:56:46Z

1

If you are creating tables on the fly in your application, you will missed some fundamentals about database design. In a relational database, the set of tables and columns are supposed to be constant. They may change with the installation of new versions, but not during run-time.

You can check it here

create proc createdb @dbname sysname
as
declare @sql nvarchar(max)
set @sql = 'create database ' + QUOTENAME(@dbname)
exec (@sql)

Here you can pass @dbname as parameter

answered Jun 26, 2014 at 8:56

CodingDefined

2,1621 gold badge17 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Run Sql Script File With Passing database name from C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related