Passing multiple array values to a web api controller using a single model attribute

Question

I have a $scope object as bellow

$scope.array=[{"ID":"1","ID":"2","ID":"3"}];

What I want to do is pass these values to the following SQL query

Select * from table where ID in("Here I need the above 3 values one after another")

How can I do this?

That is the thing I want to know. Can I pass this array values using a List<> in the Model? — Tharindu Senanayake
– Tharindu Senanayake, Commented May 25, 2016 at 3:13

Anik Islam Abhi · Accepted Answer · 2016-05-25 03:17:37Z

1

Create a class

public class myId {
  public int ID {set;get;}
}

pass it to web api

public void submitID(List<myId> ids){
  // do rest of the things
  var id = string.Join(",", ids.Select(x => x.ID).ToArray());
  var query="Select * from table where ID in('"+id+"')";

}

answered May 25, 2016 at 3:17

Anik Islam Abhi

25.4k8 gold badges61 silver badges82 bronze badges

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

2 Comments

Tharindu Senanayake Over a year ago

If I'm using a model with multiple attributes public class model{ public int ID {get;set;} public int age{get;set;} } how can I get the values?

Anik Islam Abhi Over a year ago

this value have to in json object otherwise it won't pass. It will catch those which property mentioned both in class and json object @TharinduSenanayake

Collectives™ on Stack Overflow

Passing multiple array values to a web api controller using a single model attribute

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related