<div>
Hmm I get the feeling that you think a CLR object is directly accessible to your VB code. &nbsp;That is not true.<br />
<br />
Creating CLR functions is a way to write your own custom SQL objects to use within your SQL code.
</div>


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.

<div>
Ok,<br />
How do I do that? Is there some examples out there?
</div>


Ok,
How do I do that? Is there some examples out there?

<div>
Thanks TedBilly,<br />
No I understand it much better.
</div>


Thanks TedBilly,
No I understand it much better.

<div>
It is a really cool option in SQL 2005. &nbsp;The regular expression UDF is the first one I did. &nbsp;Cheers
</div>


It is a really cool option in SQL 2005.  The regular expression UDF is the first one I did.  Cheers

<div>
<div class="content wysiwyg-content">
Hi,<br />
This is the first time I am trying to attempt this, so please be patient. <br />
<br />
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?<br />
<br />
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.......<br />
<br />
Thank you VERY much!!!
</div>
</div>


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!!!

Creating a CLR Object

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.

Web Applications

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.