Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Creating a CLR Object

Hi,
This is the first time I am trying to attempt this, so please be patient.

I am trying to create a CLR object to my SQL server. I am trying to retrieve Department names and then later Items that are associated with those Departments. At this stage I am only worried about departments. Ho do you create that in Visual Basic and then how can you use that CLR?

My goal is to use the CLR in a WPF web application, but I need to get the CLR working first. I would really appreciate the help. This is something that I have been trying to get to work now for 2 weeks, but with no avail.......

Thank you VERY much!!!
0
ALawrence007
Asked:
ALawrence007
  • 3
  • 2
1 Solution
 
Ted BouskillSenior Software DeveloperCommented:
Hmm I get the feeling that you think a CLR object is directly accessible to your VB code.  That is not true.

Creating CLR functions is a way to write your own custom SQL objects to use within your SQL code.
0
 
ALawrence007Author Commented:
Ok,
How do I do that? Is there some examples out there?
0
 
Ted BouskillSenior Software DeveloperCommented:
Here is a cool example that creates a function for using regular expressions in SQL: http://blogs.msdn.com/sqlclr/archive/2005/06/29/regex.aspx
0
 
ALawrence007Author Commented:
Thanks TedBilly,
No I understand it much better.
0
 
Ted BouskillSenior Software DeveloperCommented:
It is a really cool option in SQL 2005.  The regular expression UDF is the first one I did.  Cheers
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now