This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I could not determine in the forums if there is official support for using an Inline or Table value function (udf) in Sql 2005+ being treated like a stored procecudure in LS? I Have a series of udf's used in current cases that use this to populate dropdowns and create objects. Also if it is supported, are both the parameters (Select * from udf_Name(@param1)) and the where clause supported? Thanks, Joe Feser |
|
|
|
|
Hi Joe, If I am reading you correctly than what you are asking is are UDF's supported as a source for entities records in the same way that a Table, a View or a Stored Procedure is? If so, then the answer is no - these are not natively supported as an entity source which we would construct SQL to query against. There is of course nothing stopping you from wrapping these with a view or a stored proc. I like the idea of this however - we did a blog post earlier in the year about supporting more specific provider capabilities (at the time I was looking at SQL 2008) but in general we would be keen to look at supporting any handy optimizations or capabilities that make good sense for specific providers. Ill add a ticket for this to our backlog and hopefully its something we can look at early after v3 :)
Jeremy |
|
|
|
