SqlConnectionCommand ( CREATE DATABASE)

Question

Does anyone know why the first code works but the second does not? At the second I get exception (wrong syntax near @databaseName).

First Code

public void CreateDatabase(string databaseName)
{
     string command = "CREATE DATABASE " + databaseName;
     using (SqlConnection sqlConn = new SqlConnection(_sqlConnectionStringBuilder.ToString()))
     {
          sqlConn.Open();
          using (SqlCommand sqlComm = new SqlCommand(command, sqlConn))
          {
               sqlComm.ExecuteNonQuery()
          }
     }
}

Second Code

public void CreateDatabase(string databaseName)
{
     string command = "CREATE DATABASE @databaseName";   \\I tried both
     string command = "CREATE DATABASE '@databaseName'";  \\I tried both
     using (SqlConnection sqlConn = new SqlConnection(_sqlConnectionStringBuilder.ToString()))
     {
          sqlConn.Open();
          using (SqlCommand sqlComm = new SqlCommand(command, sqlConn))
          {
               sqlComm.Parameters.Add(new SqlParameter(@"databaseName", databaseName));
               sqlComm.ExecuteNonQuery()
          }
     }
}

Because you can't use a parameter for a ddl statement. Why do you need to create a database in your application anyway? — Sean Lange
– Sean Lange, Commented May 4, 2018 at 18:10
thank you. because I am currently learning MVVM and would like to write a sample program — Zappelig
– Zappelig, Commented May 4, 2018 at 18:13
Possible duplicate of SQL Server: How to use a database name as a parameter in a stored procedure? — Tab Alleman
– Tab Alleman, Commented May 4, 2018 at 18:24
Not sure why that requires you to constantly need more databases but I will just pass that as a different discussion. — Sean Lange
– Sean Lange, Commented May 4, 2018 at 18:47

David Browne - Microsoft · Accepted Answer · 2018-05-04 18:25:52Z

1

In TSQL the general rule is you can't parameterize Data Definition Language (DDL) statements at all. And you can't use parameters in place of identifiers in Data Manipulation Language (DML) statements.

edited May 4, 2018 at 18:25

answered May 4, 2018 at 18:11

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

SqlConnectionCommand ( CREATE DATABASE)

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