Pastable version of Common StProc Code

<pre class='prettyprint' language='cs'>void CopySourceTables(List&lt;TableNameResult&gt; tables, int id)
{
    // Execute the &quot;Copy&quot; Command on the Server for Each Table.
    using (SqlConnection conn = tgtConnStr_.CreateConnection())
    {
        conn.Open();
        using (SqlCommand comm = new SqlCommand(&quot;sp_CopySourceTableToTargetTable&quot;, conn))
        {
            // create params.
            SqlParameter source = new SqlParameter(&quot;@source&quot;, SqlDbType.VarChar, 255);
            source.Value = srcConnStr_.DatabaseName;
            comm.Parameters.Add(source);
            SqlParameter target = new SqlParameter(&quot;@target&quot;, SqlDbType.VarChar, 255);
            target.Value = tgtConnStr_.DatabaseName;
            comm.Parameters.Add(target);
            SqlParameter schema = new SqlParameter(&quot;@schema&quot;, SqlDbType.VarChar, 255);
            comm.Parameters.Add(schema);
            SqlParameter table = new SqlParameter(&quot;@table&quot;, SqlDbType.VarChar, 255);
            comm.Parameters.Add(table);
            SqlParameter tableID = new SqlParameter(&quot;@tableOID&quot;, SqlDbType.Int, 0);
            comm.Parameters.Add(tableID);
            SqlParameter snapshotID = new SqlParameter(&quot;@snapshotID&quot;, SqlDbType.Int, 0);
            comm.Parameters.Add(snapshotID);

comm.CommandType = CommandType.StoredProcedure;
            comm.Prepare();

int tblCount = tables.Count;
            int currTbl = 0;

foreach (TableNameResult tbl in tables)
            {
                schema.Value = tbl.User;
                table.Value = tbl.Table;
                tableID.Value = tbl.ID;
                snapshotID.Value = id;

RaiseOpProgressEvent(new OpEventArgs(&quot;Copying Table Data: '&quot; + table.Value + &quot;'&quot;, tblCount, currTbl += 1));

comm.ExecuteNonQuery();
            }
        }
    }
}</pre>
<a href="http://www.refactormycode.com/codes/273-common-stproc-code" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of Common StProc Code