Filtering Typed Views

Posts   
 
    
ElQueso avatar
ElQueso
User
Posts: 27
Joined: 08-Oct-2005
# Posted on: 22-Jan-2006 01:00:29   

Hope this hasn't been covered before...looked for something, but couldn't find it.

I have a TypedView that is based on a view from a table in another database. I am linking that database to my existing database in SQL Server and then creating the view in SQL Server.

The problem is, my GenPro project knows nothing about the other database except for the view. When I try to filter the TypedView in GenPro, I find that I have to use EntityFields.FieldName in my predicate. Unfortunately I don't have an entity from which to get a list of fields.

The only other thing I can think to do is use the Select property. or something similar, to return the row I'm looking for. The only problem I have with that is Select returns a DataRow, and I like the aspect of having a typed object returned (like the TypedViewRow).

Am I missing something obvious, or is this simply a limitation?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 23-Jan-2006 11:18:18   

Filtering typed views is done by using the typedview's fields object. So TypedViewFields.FieldName.

Frans Bouma | Lead developer LLBLGen Pro
ElQueso avatar
ElQueso
User
Posts: 27
Joined: 08-Oct-2005
# Posted on: 26-Jan-2006 04:46:59   

Ever have a mental block that is so string it's almost painful? frowning

Heh - sorry for the obvious question. I've managed to resolve every issue I've come across so far, with only one other request for help. This one fell through the cracks of my mind, so to speak...