View GetAll() to generate TList<TableName> instead of VList<ViewName>

 I've made a view (called: MaleCustomers) which shows all male customers (select customer.* from customers where gender = 'Male').

The view returns an exact structure of the customer table.

.netTiers generates an entity MaleCustomers and a provider MaleCustomersProvider which has a method GetAll() which returns VList<MaleCustomers>.

is there a way to get MaleCustomersProvider.GetAll() return a TList<Customer> instead? 

For views, the return type is VList... no way to change that. );

You can create custom stored procedures to return costumers by Gender. Views with the same columns of tables make no sense to me..

TList<Costumer> maleCostumers =  CostumerProvider.GetByGender('Male');

vbandrade you saved me :)

I used views instead of stored procedure because i thought the result of a stored procedure would be the same (VList<ProcName>).

I followed your advice and search this forum for custom stored procedures and found just what I was looking for.

If I wish to have a query return a result based on a specific table I sould create a custom stored procedure and name it: _TableName_ProcName

and the result would be of TList<TableName> instead of VList<ProcName>.

example: _Customer_GetByGender will return TList<Customer>.

 I hope this helps other new .netTiers users like me.

Thanks again vbandrade.

Would it not be better to have an index on the Gender column in the first place? You will then get a GetByGender method generated anyway.

It might even be better to split the Gender field out to a an enum lookup table and then have a FK on the Customer.  Then rather than having to pass in a hard coded string such as "Male" or "Female" you'll be able to do:

CustomerProvider.GetByGender( (int)Gender.Male) or my preference

CustomerService customerService = new CustomerService();
TList<Customer> customerList = customerService.GetByGender((int)Gender.Male);

which in my opinion is better because any changes to Gender will be caught at compile time and it should be slightly faster as the index will be over a numeric value (supposingh you use an Identity int)

hth

swin 

Swim, That´s why you´re the none in charge. (;

Golan, swim´s solution is waaay cleaner and nice than mine and also performs better..

 Thank you swin for your solution.

I'm new to .netTiers.

could you please tell me how to create an enum lookup table?

 found it

http://community.codesmithtools.com/forums/t/7263.aspx

http://community.codesmithtools.com/forums/t/1095.aspx