Asp.Net Core : Get the list values ​of a table by string Id with Linq?

sunboy_sunboy 0
Viewed 91

I have a color table that contains values, and I have a string of IDs that are the IDs of this table.I want to return only values ​​whose ID is in the string of IDs

Table Color: enter image description here

string Ids :

1,3,5

I want to receive the values ​​whose IDs are 1, 3, and 5 as a list ?

linq asp.net-core c#
4 Answers
List<string> result = Datatable.Rows
   .Cast<DataRow>()
   .Where(x => listOfId.Contains((int)x["Id"])) //This part does the filtering of id
   .Select(x => x["Name"])
   .ToList()
Mrudhula Katta0 
int[] ids = { 1, 3, 5 };
var colors = (from d in ids from c in Colors where d == c.Id select c).ToList();
usersOOr0

Since you wrote Linq in the TAGs, I assume that you are using EntityFrameworkCore or LINQ to SQL or something similar.

In this case, this example will help you:

int[] ids = { 1, 2, 3 };

var nameList = db.Colors
    .Where(x => ids.Contains(x.Id))
    .Select(x => x.Name)
    .ToList();

where db is DbContext

giorgi020

With EF Core you have to use Contains:

var ids = stringIds.Split(',')
   .Select(s => int.Parse(s))
   .ToArray();

var colors = db.Colors
    .Where(x => ids.Contains(x.Id))
    .ToList();
Svyatoslav Danyliv0
Related