Is it possible to use Linq to LLBLGen to fetch data from Stored procedures? I would like to do the same as the next example:

http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

no that's currently not supported (also not planned for v3), you need projections for that or use the calls generated.

Otis wrote:

no that's currently not supported (also not planned for v3), you need projections for that or use the calls generated.

Too bad it's not supported. Would make things a lot easier. Currently I've the following code but there must be an easier way to do this:

UmbracoProductCollection umbracoProductCollection = new UmbracoProductCollection();
            using (IRetrievalQuery query = RetrievalProcedures.GetSpDigiGetRecursiveUmbracoProductsCallAsQuery(productGroupCode))
            {
                TypedListDAO dao = new TypedListDAO();
                using (IDataReader reader = dao.GetAsDataReader(null, query, CommandBehavior.CloseConnection))
                {
                    List<IDataValueProjector> valueProjectors = new List<IDataValueProjector>();
                    valueProjectors.Add(new DataValueProjector(UmbracoProductFieldIndex.UmbracoProductId.ToString(), 0, typeof(Guid)));
                    valueProjectors.Add(new DataValueProjector(UmbracoProductFieldIndex.FirstProductName.ToString(), 1, typeof(string)));
                    DataProjectorToIEntityCollection projector = new DataProjectorToIEntityCollection(umbracoProductCollection);
                    dao.GetAsProjection(valueProjectors, projector, reader);
                }
            }

Currently I've the following code but there must be an easier way to do this:

That's the only way to go if you want projection.

Walaa wrote:

That's the only way to go if you want projection.

And what are the other options besides projection?

Use call the SP and having the results returned in a dataTable.

Walaa wrote:

Ust call the SP and having the results returned in a dataTable.

And is there an easy way to convert a datatable into an EntityCollection or can this only be done using projections?

Thank you for the help so far!

Either projection or use your own code that copies values from the database into an entities that gets added to the EntityCollection, but no point in doing that when you can just use the projection. (In fact I don't think the projection code is too much to use).

I created my own generic method to convert a Stored Procedure to a collection. You can find it here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=17023&StartAtMessage=0&#95330