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<Com panyTypevalidTy pes= ...;
var v = from c in db.Companies
where validTypes.Cont ains(c.CompanyT ype)
select c;

I got an exception says:

Method 'Boolean Contains(MyName space.CompanyTy pe)' has no
supported translation to SQL.

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

Thanks!

[deerchao]

On Jun 24, 12:23*pm, deerchao <deerc...@gmail .comwrote:

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<Com panyTypevalidTy pes= ...;
var v = from c in db.Companies
* * where validTypes.Cont ains(c.CompanyT ype)
* * select c;

I got an exception says:

* * Method 'Boolean Contains(MyName space.CompanyTy pe)' has no
supported translation to SQL.

If I use int instead of "MyNamespace.Co mpanyType" as the type of
property "CompanyTyp e" (and the IEnumerable<int validTypes),
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<Com panyTypebut HashSet<Company Type>.
Everything works after I change the declared type of validTypes into
IEnumerable.