What do you need this for? Isn't the data API enough? By the way, all methods in managers that return more than one item return an IList
. IList implements IEnumerable
. I suppose you want to use it for data binding. The returned IList could be filtered with LINQ
, and the query
result made a data source.
We do not use SQL queries directly, we use Nolics.NET
for this purpose, as it provides nice features, such as forward mapping. In the next version of Sitefinity, we are going to use another ORM
solution - OpenAccess
. Since you have purchased a Sitefinity license, you already have a license to use Nolics.NET in your Sitefinity projects. I suggest you use either OpenAccess or Nolics.NET instead of using pure SQL. If you are working with the Sitefinity data layer, it is best to use the provided API.
the Telerik team