Thanks for the more detailed explanation. Based on this info, I have some options that I can think of.

1. Functions can't be imported and used in LINQ but Stored Procedures can. So one suggestion is to rewrite your SQL Scalar Functions to SQL Stored Procs.

2. If you have to stick with Functions, consider re-writing your query such that it doesn't use projections. In other words, separate the query into 2 queries. 

eg: 

I wish I could be more helpful. We have our Professional Services if you'd like to find out more about best practices in solving this kind of problems.

Hi Denis,

I'm still trying to understand why you need to use EntitySql. You said that the query may get very complex with where-clause and many sub-selects, as well as using SQL scalar functions, but I still don't see why this can't be done with LINQ. LINQ queries are pretty powerful as shown by these examples. http://drc.ideablade.com/xwiki/bin/view/Documentation/query-101-examples

You said that you already tried to extend your entity with the "rating" property but you weren't able to fill it with the function's return value. Is this a stored proc function that you're talking about? What was the issue that you're encountering with this?

Perhaps, if you can show me an example of the complex query, I'll be able to help better.

I've tried to find a good solution using SPs but it didn't work out for me. So maybe you can give me another advice. My problem is that I need to call a SQL (scalar) function which returns a rating (int number) along with the entity. Based on the rating I have to sort the entities in my Silverlight client. As the query may get very complex (where-clause with many sub-selects) and because I have to call SQL functions in it I switched to EntitySql.

Any ideas I can handle this?

Thanks,

Sven

For some reason, I didn't see that you've said you couldn't use LINQ. My apologies.

Unfortunately, for the time being DevForce doesn't support projection with E-SQL. My immediate suggestions are to consider using RSMC, http://drc.ideablade.com/xwiki/bin/view/Documentation/rsmc-query or Stored Procs, http://drc.ideablade.com/xwiki/bin/view/Documentation/stored-procedure-queries.

I might be able to give more specific suggestions if you can let me know your specific use case.

Thanks for your response. Do you have some documentation using projection in EntitySql instead of Linq? 

See if this page can help you. http://drc.ideablade.com/xwiki/bin/view/Documentation/query-anonymous-projections

I'm using EntitySql in a Silverlight client to retrieve my data. Due to complex queries and functions inside SqlServer, I wasn't able to use Linq. As long as I am retrieving whole Entites (e.g. Select Value xy from Entity as xy ...) I have no problems. But now I need to return some value calculated sqlserver-side along the entity, so I need a projection. Sorry, I can figure out how to do that. I already tried to extend my Entity with an additional property but the I wasn't able to fill it with the function's return value. Maybe you can help me a little bit.

Thanks in advance,

Sven