API: Send datatable as parameter to stored procedure

  • Thread starter Thread starter old_School
  • Start date Start date
O

old_School

Guest
I have an idea after watching a video tut on Sending datatable as parameter to stored proc and need feedback. I have an API and I want to store update data sent to my API for a set period of time. Every 5 mins for example, I want to call my database and perform the update passing the data table as a parm to the stored proc. Basically one giant update every 5 mins as apposed to making literally thousands of to my database over a 5 min period of time. Is this possible? Can I use timers in API's? I've never stored data in an API is that even possible?

Continue reading...
 

Similar threads

M
Select from result set of stored procedure
Replies
0
Views
107
monemas
M
Z
call stored procedure but use parameter to insert data like object
Replies
0
Views
132
zleug
Z
E
How to run procedure exist on database different from current database I connected and another database on same server ?
Replies
0
Views
84
engahmedbarbary
E
E
How to replace string sTSQL parameter with stored procedure spqueRun on csharp clr function ?
Replies
0
Views
78
engahmedbarbary
E
V
Can I use Visual Studio C# to build web API with similar feature?
Replies
0
Views
90
VA_er
V
Back
Top