samedi 9 mai 2015

best practice Executing Multiple SQL Server stored procedures from c# with minimum round trips to DB Server

I had a windows service running in the background that need to execute about 1000 sql parametrized update query every N minutes ,So I want to do this in the best practice way , one that a code reviewer won't blame me for using . I had a look at multiple posts here , also here and I wonder if i can just write a large sql text query in my code .Will this lead to my code smells bad to a Microsoft code reviewer ? thanks

Aucun commentaire:

Enregistrer un commentaire