Below is an example which shows how to use "context" to access dbase within a CLR assembly
{
...
[Microsoft.SqlServer.Server.SqlFunction]
public static int DBBackup()
{ // local variables
SqlConnection conn = null;
SqlCommand cmd = null;
try
{ conn = new SqlConnection("context connection=true");
conn.Open();
strCmd = "insert DBase_Ctrl..dbase_backup_log (log_event) values('Test')";
cmd = new SqlCommand(strCmd, conn);
cmd.CommandText = strCmd;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{ if (conn != null) { conn.Close(); conn = null; }
}
...
}
Friday, January 8, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment