ASP.NET Core SQL Linq using list of strings

Question

I have a list of strings like this

list = {a,b,c}

I would like to compare it in the database but I'm not sure how to go about doing that. This is my linq query:

var initialData = (from item in dbContext.DocumentCategories
    join df in dbContext.DocumentFields
    on item.Id equals df.DocumentCategoriesId
    join dfs in dbContext.DocumentFieldsStore
    on df.Id equals dfs.DocumentFieldsId
    select new SearchDocumentsListViewModel
    {
        CategoryId = item.Id,
        DocumentId = dfs.DocumentsId,
        FieldId = df.Id,
        Data = dfs.Data
    })
    .ToList();

initialData = initialData
    .Where(u => u.Data.Contains(list))
    .ToList();

Currently its showing me this error:

cannot convert from 'System.Collections.Generic.List' to 'char'

Not sure what that means

Should the Where at the end be flipped to .Where(u => list.Contains(u.Data))? Seems like data might be a string. — Nathan Werry
– Nathan Werry, Commented Dec 8, 2018 at 3:38
Because you were asking the question of "Does your string contain the list?" instead of "Does your list contain the string" — Nathan Werry
– Nathan Werry, Commented Dec 8, 2018 at 3:42
Thank you! I understand it now. Do you want to put it in an answer — JianYA
– JianYA, Commented Dec 8, 2018 at 3:44

Nathan Werry · Accepted Answer · 2018-12-08 03:46:26Z

2

There is a Where statement at the end that has the Contains expression backwards.

.Where(u => u.Data.Contains(list)

This line of code explained: u.Data is being treated as a char[] and a char cannot contain a list.

This line of code needs to have the contains flipped around to:

.Where(u => list.Contains(u.Data)

answered Dec 8, 2018 at 3:46

Nathan Werry

8968 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

ASP.NET Core SQL Linq using list of strings

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