• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

how do i make a transaction in WEB API?

is it possible to make a transaction in web api? i have searched google,but there is no anwser yet.how do i make a transaction in web api?my database is sql server
ken yup
ken yup
  • 2
1 Solution
Just use transaction in the stored procedures.  easier than putting it in c# code
ken yupAuthor Commented:
however  stored procedures seems not support array
DECLARE @MyArray varchar(50)
SET @MyArray = "this|is|a|pipe|delimited|string"

or pass @MyArray from c# code

you can make a function that will accept raw string and output a table, with each item as a row.  you can google for this
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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