C# CLR Assembly Query

Question

I am creating a C# assembly for MS SQL Server 2005 for encryption/decryption.

I need to query the database in this assembly, and was wondering what the preferred method of connecting to the database is? I believe we would not want to have a username/password in the connection string.

Since the assembly is registered in MS SQL does it have some sort of quick way to access data in the database?

I'm a little bit of a newb as it related to Integrated Security or Trusted Connections.

Answer 1

You can use the following connection string when using CLR stored procedures:

  using(SqlConnection connection = new SqlConnection("context connection=true")) 
  {
      // ..
  }