linq mysql query into int array

Question

I'm still very new in my linq skills. I have a mysql query that returns 3 records, each record is an int. I want to stick those ints into an array. I thought I could make it easy on myself and do that with a linq command instead of creating a reader and looping through the results. Here is my code:

query = "SELECT cic.catid FROM cart_item ci LEFT JOIN cart_item_category cic USING (itemref) WHERE ci.pid = @pid";

try
{
    item.catIDs = con.Query(query, new { pid = ImId}).ToArray();
}
catch(MySqlException ex)
{

}

I am getting the error: Cannot implicitly convert type 'dynamic[]' to 'int[]'

I'm assuming my linq query is not correct.

try new int[] { pid = ImId }. You create a dynamic type when you do new { pid = ImId } or make item.catIDs a dynamic[] — DGibbs
– DGibbs, Commented Dec 9, 2015 at 15:53

Lewis Taylor · Accepted Answer · 2015-12-09 17:32:48Z

1

Instead of using

con.Query(...

try using

con.Query<int>(...

answered Dec 9, 2015 at 17:32

Lewis Taylor

7273 silver badges13 bronze badges

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

Comments

Avinash Jain · Accepted Answer · 2015-12-09 17:41:11Z

0

Look like catIds is array of integer, But you are trying to assign anonymous collection to integer which is not correct.

Please try the below code. I think it should work

query = "SELECT cic.catid FROM cart_item ci LEFT JOIN cart_item_category cic USING (itemref) WHERE ci.pid = @pid";

try
{
    item.catIDs = con.Query(query, Convert.ToInt32(ImId)).ToArray();
}
catch(MySqlException ex)
{

}

answered Dec 9, 2015 at 17:41

Avinash Jain

7,6862 gold badges29 silver badges40 bronze badges

Collectives™ on Stack Overflow

linq mysql query into int array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related