|
Comments
|
|
Simple and to the point. Great! Thank you.
|
|
Thomas Kelley on
5/21/2010
Thanks. I was curious how the parameterized SQL differed from the select all. I will check out the project. Thanks for posting.
|
|
Marcelo Marim on
5/21/2010
Good Stuff.
|
|
Dennis Allen on
5/21/2010
Great organization
|
|
|
really good stuff.
|
|
|
Nice.. would be even nicer if there was a sample project to download ;-)
|
|
|
Ooops.. sorry, my bad.. I missed the download until now.
|
|
|
audibility is not clear.
|
|
|
I guess you had already commented out the "alter" stuff at the top of the file for the contact stored procedure - I expected you were going to do that in the video.
|
|
Jules Wensley on
5/26/2010
Very useful
|
|
|
I wonder if it works with more complex sql that contains multiple queries and/or loops?
|
|
|
Mark,
One thing to keep in mind is that SQL Compact will only execute the first query in a batch. While this can be viewed as a limitation, it also protects the framework from SQL Injection. If you have a need to process mutiple queries there are code examples available that split the query into seperate batches on the keyword "GO". There were sacrifices made to allow the framework to be so compact and light-weight, but please keep in mind that since your app is so close to the data (no round trips to a service on another machine) you can do your complex code and loops in C#/VB and just keep your T-SQL for simple CRUD statements.
I hope this answers your question.
|
|
|
Good. Could be better example typing was not clean. had to watch again to see mistake.
|