Conversion error (nvarchar to int) for SQL query using MVC4

Question

This code I received from another stackoverflow post from Agent Shark and changed it slightly for my use. Problem is I get an error:

Conversion failed when converting the nvarchar value '39432,39431,39430,39429,39428' to data type int.

Question is, how do I fix this problem?

The original StackOverFlow Post:

What is the best method to access a large database using MVC 4 and Entity Framework 6

Here is the code I'm using:

public void DeleteBatchCampaignContacts(IList<int> ids)
{
    if (ids == null) return;
    if (ids.Count == 0) return;

    var idsToDelete = new StringBuilder();

    foreach (var id in ids)
    {
        idsToDelete.AppendFormat(",{0}", id);
    }

    db.Database.ExecuteSqlCommand("DELETE FROM EmailContactCampaign WHERE EmailContact_EmailContactId in (@contactIds)",
    new SqlParameter("@contactIds", idsToDelete.ToString().Remove(0, 1)));
}

You must use `table-valued parameter` in conjunction with `SqlDbType.Structured`. — Hamlet Hakobyan, May 09 '14 at 19:44
@Hamlet gave you two great **keywords** to use for (re)searching a solution to your problem! Just go and google and then read, learn and apply what you've learned .... — marc_s, May 09 '14 at 19:46
OK, I 've got my homework. Thanks for the the helping hand. :) — user2789697, May 09 '14 at 19:53

score 1 · Accepted Answer · answered May 10 '14 at 02:02

1

Database.ExecuteSqlCommand(string.Format("DELETE FROM CampainContacts WHERE CampaignId in ({0})", idsToDelete.ToString().Remove(0, 1)));

answered May 10 '14 at 02:02

Agent Shark

517
2
6

Conversion error (nvarchar to int) for SQL query using MVC4

1 Answers1