Linq 2 sql, enum, no supported translation to SQL

[deerchao]

Hi, I'm using linq 2 sql, and I specified a custom enum type
(CompanyType) to one of the Company table field.
When I'm querying like this:

IEnumerable<CompanyTypevalidTypes= ...;
var v = from c in db.Companies
where validTypes.Contains(c.CompanyType)
select c;

I got an exception says:

Method 'Boolean Contains(MyNamespace.CompanyType)' has no
supported translation to SQL.

If I use int instead of "MyNamespace.CompanyType" as the type of
property "CompanyType" (and the IEnumerable<intvalidTypes),
everything works. So what should I do to make my custom enum types
work?

Thanks!

[deerchao]

On Jun 24, 12:23*pm, deerchao <[e-mail]:

Hi, I'm using linq 2 sql, and I specified a custom enum type
(CompanyType) to one of the Company table field.
When I'm querying like this:

IEnumerable<CompanyTypevalidTypes= ...;
var v = from c in db.Companies
* * where validTypes.Contains(c.CompanyType)
* * select c;

I got an exception says:

* * Method 'Boolean Contains(MyNamespace.CompanyType)' has no
supported translation to SQL.

If I use int instead of "MyNamespace.CompanyType" as the type of
property "CompanyType" (and the IEnumerable<intvalidTypes),
everything works. So what should I do to make my custom enum types
work?

Thanks!

Sorry, it's my fault.
I checked again, the validTypes is not of Type
IEnumerable<CompanyTypebut HashSet<CompanyType>.
Everything works after I change the declared type of validTypes into
IEnumerable.