WebMatrix Alternative for SqlCommand.Parameters.Add

Question

I've used WebMatrix for parameterized query like:

string sql = @"SELECT col FROM table WHERE id = @0 AND name = @1";
db.Query(sql, someID, someName);

But I got stuck on unknown count of parameters. In traditional ADO.NET solution we have SqlCommand.Parameters.Add so we can add parameters one by one programmatically.

Is there any alternative like SqlCommand.Parameters.Add in WebMatrix?

Can't you supply it with an array of objects as the second parameter? — rene
– rene, Commented Jan 12, 2018 at 21:55
@rene Yes you're right.. I found the solution myself. Thanks anyway! — mriiiron
– mriiiron, Commented Jan 12, 2018 at 22:08

mriiiron · Accepted Answer · 2018-01-12 22:09:10Z

1

OK.. I found the solution myself in this blog post. The key point is Database.Query() method accepts an array of Objects.

So given an array of parameters and properly construct the SQL string would do the work.

answered Jan 12, 2018 at 22:09

mriiiron

1174 bronze badges

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

Collectives™ on Stack Overflow

WebMatrix Alternative for SqlCommand.Parameters.Add

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related