sproc --> entityCollection

Posts   
 
    
yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 14-Jun-2006 14:20:02   

version 1.0.2005.1 final (self-servicing) asp.net 2.0

Hiya,

I want to use a sproc as the basis for an entityCollection. I intend to grab all the fields that are referenced in the sproc and create an entity. Any filtering that is done in the sproc, I will do via predicates.

The sproc will then be discarded..This sounds like a daft question, but is that the way to proceed?

many thanks,

yogi

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 14-Jun-2006 15:26:28   
yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 14-Jun-2006 15:45:06   

hiya Walaa,

Sorry for the confusion, what I mean is...

<<If I have a sproc, could the IDE create an entity based on this sproc?>>

I assume that the answer is no, and that I have to do it manually?

At no stage in my app will I need a sproc, I was just going to use the sproc as a "starting point" for creating an entity.

Make sense?

many thanks,

yogi

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 14-Jun-2006 15:51:49   

If I have a sproc, could the IDE create an entity based on this sproc? I assume that the answer is no, and that I have to do it manually?

By the IDE I guess you mean the LLBLGen Pro Designer. If so, unfortunatly the answer would be no, the designer reads the schema from the database, then you may map tables as entities, select and deselect fields in each entity, and define typed lists if possible.

So you are correct, you have to do it manually.

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 14-Jun-2006 16:02:14   

righto,

It was worth a punt anyway :-)

ta for the quick reply.

yogi