Yes you can execute PARAMETERIZED sprocs with EF Fluent API Code Only (and more!)

This is really an add-on to this post here. Turns out most people were only thinking that you could execute SQL strings only as opposed to detailed parameterized SQL statements. That’s not correct. It’s all supported and approved. Scenario 1. Using Parameterized SQL statements So this covers selects as well as invoking sprocs. If you…

0

SQL Tip of the Day

HAd this passed to me from the SQL Tips DL here at the ‘soft and decided to repost it here to 1. remember about it and 2. share the tidbit INSERT MULTIPLE RECORDS WITH TABLE VALUE CONSTRUCTOR Author: Saleem Hakani (Microsoft Corporation)   Wouldn’t it be nice to have the ability to insert multiple rows…

2

Server Side Pagination in T-SQL / LINQ

OK it came as a shock to me that so many people were building huge sets of query data that they are binding in their UI and then deciding to page it at like 10 rows per page. I’m not talking about 1 or 2 or even 3 pages of data, I’m talking about hundreds…

0

SIDs in T-SQL

If you are in a situation where you need to pass a windows domain user into SQL then you might want to think about this. The most reliable way is to use the user’s SID (security identifier) because SIDs never change (aliases can possibly change); however, it may not be technically feasible. An example of…

0