Executing Sqlscript file from c# code

Try this:

Add these namespaces to your application:

using System.Data.SqlClient;

using System.IO;

using Microsoft.SqlServer.Management.Common;

using Microsoft.SqlServer.Management.Smo;

Add this code:

            string sqlConnectionString = "Your connection string here";

            FileInfo file = new FileInfo("Your .sql file or SQL string here ");

            string script = file.OpenText().ReadToEnd();

            SqlConnection conn = new SqlConnection(sqlConnectionString);

            Server server = new Server(new ServerConnection(conn));

            server.ConnectionContext.ExecuteNonQuery(script);

If you don't see namespaces, add DLL reference to the project.

If your script is too large, you may want to parse it and break into chunks and execute them.