Hi - is it possible to specify an "else" as a discrimantor value?

So for example, say I have a table with a "code" attribute, is it possible to resolve this to:

A -> typeof(CodeA)
B -> typeof(CodeB)
NULL | string.Empty | Any other string -> typeof(CodeC)?

I'm fully aware that this isn't good DB design. I didn't make the DB, or the legacy system that this is built on top of...

I can't see anything in the documents - but then that's assuming some form of consistent design...!

Cheers

I'm not quite sure, but a filter might work. Define a filter for class C , which restricts the results to rows that contain anything except A or B in the code column.
If A,B and C build a class hierarchie (e.G. B : A, C : B, you will loose some functionality, because you can't query on A and get all B's and C's. But if C has nothing to do with A or B or you don't need polymorphic queries, that approach might work.