How can I call SQL Server database function from MVC3 controller? [duplicate]

Question

Possible Duplicate:
How to use SQL user defined functions in .NET?

Say I have created a SQL Server function function1(int a,int b) in my database, now how can I call this function in MVC3 controller ?

I think you should do that in model, not in controller. Model consists of application data and the controller mediates input, converting it to commands for the model or view. — Pablo Claus
– Pablo Claus, Commented Jul 4, 2012 at 20:15
Pabloker is correct. You call the function in your SQL. And your SQL comprises the model. — paulsm4
– paulsm4, Commented Jul 4, 2012 at 20:33

bluevector · Accepted Answer · 2012-07-04 19:30:48Z

0

You would use either ADO.NET or any one of many other database technologies.

answered Jul 4, 2012 at 19:30

bluevector

3,5031 gold badge17 silver badges18 bronze badges

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

1 Comment

Then you want to do this