Call vb.net function from sql

Question

0.00/5 (No votes)

See more:

Hi guys,

Maybe someone of you can help me with that problem.

I have written a background task which gets several workers out of a database.
In the database I added to each worker the name of the function which should get called.

But I am not sure how to call that function from vb.net.

It would be awesome if someone of you can give me a hint :)

thanks
Cheers
Arthur

Posted 20-Jul-14 4:36am

Member 9500954

Add a Solution

Comments

[no name] 20-Jul-14 10:48am

Sounds to me like a bad design but I *think* what it is that you are wanting to do is get the actual function by Reflection.

Member 9500954 20-Jul-14 10:53am

if i may ask: how would you design that? I am open for any thoughts :)

[no name] 20-Jul-14 11:23am

How I would design what? I have never heard of anyone at any time storing workers in a database so I would have no idea what it is that you have done or what you are attempting to do.

Dave Kreskowiak 20-Jul-14 11:24am

None of this makes any sense at all considering databases store DATA not "WORKERS", whatever that means.

You cannot call a method in your application from the SQL Server. Newer versions of SQL Server, however, can use what are called CLR Stored Procedures. https://www.google.com/#q=sql+server+clr+stored+procedures

nilesh sawardekar 20-Jul-14 11:41am

please explain what you want by considering we dont know your back history of your program..

Member 9500954 20-Jul-14 11:50am

Hi!
first, thanks for your replies!!

So, I think I explained it not well enough:
I created a Azure Worker role which should do the following:
- call a table with all subworkers listed (and the function names which should get called) and execute the functions.

System.Reflection might be a solution

Kornfeld Eliyahu Peter 20-Jul-14 13:46pm

I think it will be a good step to start with learning about Azure worke roles...
http://channel9.msdn.com/Series/Windows-Azure-Cloud-Services-Tutorials/Introduction-to-Windows-Azure-Worker-Roles-Part-1

Member 9500954 20-Jul-14 14:52pm

Thanks - good point :)

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)