Returning IList from a public static method

[richardFlow]

Hi,

I've a public static method on my SalesPrice class that returns sales prices based on certain parameters.

 

public static IList<SalesPrice> GetSalesPricesbyPK(int? SkuUid, SalesTypeEnum? SalesType, string SalesCode, DateTime? StartingDate)

{

 

IObjectScope scope = ObjectScopeProvider1.GetNewObjectScope();

scope.Transaction.Begin();

string  

 

oql = "SELECT * FROM SalesPriceExtent AS sp";
...
... conditional where clause building
...
IQuery query = scope.GetOqlQuery(oql);

 

 

 

 

IQueryResult result = query.Execute();

return ????????;

I have 3 questions.

1. Should i be passing in my scope object from the calling webpage to the method? Is this the best practice?
2. How do i convert from an IQueryResult to an IList<> ?
3. When is the best time to dispose the IQueryResult?  If I dispose it how do i return it?

Thanks!

 

 

 

 

 

 

[PetarP]

Hello Web Belief Ltd,

You can make your method return IList instead of IList<SalesPrice>. This way you can return IQueryResult, because IQueryResult implements IList, but its not generic collection.

Regarding your first and third question its best to take a look at our best practices knowledge base article

Regards,
PetarP
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[richardFlow]

When i try to change the return type to IList only I get the following error on compilation:

"Using the generic type 'System.Collections.Generic.IList<T>' requires '1' type arguments"

I can't get around this so far.

Regards,

Richard.

[PetarP]

Hi Web Belief Ltd,
you need to add

using System.Collections;

so that the IList type is resolved correctly.

All the best,
PetarP
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.