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.

Jakob Christensen · Accepted Answer · 2009-02-27 15:21:01Z

5

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

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

answered Feb 27, 2009 at 15:21

Jakob Christensen

15k2 gold badges53 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pasi Savolainen Over a year ago

The "using" part is very, very important. We had "connection already opened" errors pop up fairly randomly and I swear all paths closed the connections/streams/queries, but when I replaced all the explicit .Close():s with using's, it just went away.

Collectives™ on Stack Overflow

C# CLR Assembly Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related