Missing Sproc? *_Find_Dynamic

The file Sql[Entity]ProviderBase.generated.cs contains a reference to the stored procedure "dbo.[Table]_Find_Dynamic" under one of the Find() overloads.  This stored procedure, however, does not exist in the database (and yes, I set the "IncludeFind" property to true).  Is this a bug?  Does it intend to reference _GetPaged() (which is dynamic)?  I haven't noticed any errors associated with this, but found the reference and was confused by its purpose.

No, Find uses dynamic parameterized SQL, so the header for the code is there, but the implementation is done at runtime.

I'm not totally following.  So does it dynamically generate the stored procedure and then call it...?  (That seems peculiar).  Or, if it's just passing a parameterized SQL statement then why does it need a stored procedure name?  [Sorry if I'm being dense here]. 

The procedure stub is located in Procedures.xml which is embedded into the Data assembly. At run time it extracts the procedures and loads them into memory. When you call certain overloads of Find, it takes the Find_Dynamic stub, replaces some placeholders (including ones for your where clause) and executes the command. (hence why it's called "dynamic"). 

 Hi Robert,

  If it is created at runtime then I can't see in the generated code.  I did note however that it does appear in the Procedures.xml file but unlike the other stored procedures (that are created) there is a "skip" attribute on the "procedure" element:

 <procedure owner="dbo" name="User_Find_Dynamic" grant="" skip="true">

 Is this a bug or is there a switch that needs to be ticked to automatically these stored procedures?

PS  I have just done a quick review of the 2.2.0 code and noted that this functionality has _not_ been implemented. Might explain why it's not there :)

 ------------------------

Additional:  I now understand how the dynamic creation is happening.  I have isolated my issue.  I was using AppendIn which allows you to do an SQL IN Statement.  My supplied values were strings so I supplied them as I would in an SQL Query (ie 'test1','test2','test3').  This failed because of the quotes.  If I removed the quotes (ie test1,test2,test3) then the code worked fine.

I still think this is a bug that needs to be addressed in that netTiers should recognise the quotes.  For example, the following value list will cause netTiers to not funtion as expected: 'this, is my test','testing','tested, again'.  Note the commas inside the quotes.

I'll post a bug report regarding this. 

 

This has already been reported as an issue (as far as the In clause goes).

http://code.google.com/p/nettiers/issues/detail?id=39&colspec=ID%20Type%20Status%20Stars%20Priority%20Milestone%20Owner%20Summary

jeff