Generating sql code programmatically

by

As it’s already mentioned, you cas use SMO to do this, here is a an example using C# to script a database, I mentioned few options, but as it is in the post of @David Brabant, you can specify the values of many options.

public string ScriptDatabase()
{
      var sb = new StringBuilder();

      var server = new Server(@"ServerName");
      var databse = server.Databases["DatabaseName"];

      var scripter = new Scripter(server);
      scripter.Options.ScriptDrops = false;
      scripter.Options.WithDependencies = true;
      scripter.Options.IncludeHeaders = true;
      //And so on ....


      var smoObjects = new Urn[1];
      foreach (Table t in databse.Tables)
      {
          smoObjects[0] = t.Urn;
          if (t.IsSystemObject == false)
          {
              StringCollection sc = scripter.Script(smoObjects);

              foreach (var st in sc)
              {
                  sb.Append(st);
              }
           }
       }
            return sb.ToString();
 }

This link may help you getting and scripting stored procedures

More Related Contents:

  1. SQL error: Incorrect syntax near the keyword ‘User’
  2. What represents a double in sql server?
  3. Passing List to SQL Stored Procedure
  4. Code to validate SQL Scripts
  5. SqlConnection.Close() inside using statement
  6. Generate class from database table
  7. Use SQL Server time datatype in C#.NET application?
  8. Is SqlConnection.Close() need inside a Using statement?
  9. How can I round a value in SQL
  10. How do I update a value in C# and SQL Server? [closed]
  11. How to pass an array into a SQL Server stored procedure
  12. Execute Insert command and return inserted Id in Sql
  13. C# Equivalent of SQL Server DataTypes
  14. Adding multiple parameterized variables to a database in c#
  15. Read SQL Table into C# DataTable
  16. MultipleActiveResultSets=True or multiple connections?
  17. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  18. Why is a SQL float different from a C# float
  19. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  20. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  21. What is passing parameters to SQL and why do I need it?
  22. How to pass a null variable to a SQL Stored Procedure from C#.net code
  23. Is it better to execute many sql commands with one connection, or reconnect every time?
  24. Is there a .NET equivalent to SQL Server’s newsequentialid()
  25. How to Specify Primary Key Name in EF-Code-First
  26. Upload CSV file to SQL server
  27. How do I calculate the equivalent to SQL Server (hashbytes(‘SHA1’,[ColumnName])) in C#?
  28. “The operation is not valid for the state of the transaction” error and transaction scope
  29. Passing array to a SQL Server Stored Procedure
  30. Capturing count from an SQL query

Leave a Comment