¡@
c# Programming Glossary: sprochttp://stackoverflow.com/questions/1035677/using-a-stored-procedure-in-entity-framework-how-do-i-get-the-the-entity-to-hav So say you have products and categories and you have a sproc to get Products i.e. var products context.GetProducts someproductfilter.. . The guy who wrote that created the ability to write sprocs that load more data in one go. Hope this helps Cheers Alex..
What are the pros and cons to keeping SQL in Stored Procs versus Code http://stackoverflow.com/questions/15142/what-are-the-pros-and-cons-to-keeping-sql-in-stored-procs-versus-code a web service or similar to your web servers So push 1 new sproc or 4 new webservers In this case it is easier to push one new.. 4 new webservers In this case it is easier to push one new sproc but in my experience 95 of 'pushed changes' affect the code.. explain how I don't get this. Particularly seeing as the sprocs probably aren't in source control and therefore can't be accessed..
Filling a DataSet or DataTable from a LINQ query result set http://stackoverflow.com/questions/16/filling-a-dataset-or-datatable-from-a-linq-query-result-set conn MyDataTable dt new MyDataTable execute a sproc via LINQ var query from dr in db.MySproc .AsEnumerable select..
Get output parameter value in ADO.NET http://stackoverflow.com/questions/290652/get-output-parameter-value-in-ado-net conn new SqlConnection ... SqlCommand cmd new SqlCommand sproc conn cmd.CommandType CommandType.StoredProcedure add parameters.. connectionString using SqlCommand cmd new SqlCommand sproc conn Create parameter with Direction as Output and correct name..
What's a good alternative to firing a stored procedure 368 times to update the database? http://stackoverflow.com/questions/3282254/whats-a-good-alternative-to-firing-a-stored-procedure-368-times-to-update-the-d build a SQL statement consisting of sql_execs calling the sproc with the parameters in the string. Not sure if this is advised..
Using DateTime in a SqlParameter for Stored Procedure, format error http://stackoverflow.com/questions/425870/using-datetime-in-a-sqlparameter-for-stored-procedure-format-error type in the stored procedure is 'datetime'. Executing the sproc from SQL Management Studio works fine. But everytime I call.. 22 45' EDIT RE BFree the code to actually execute the sproc is as follows using SqlCommand sprocCommand new SqlCommand sprocName.. actually execute the sproc is as follows using SqlCommand sprocCommand new SqlCommand sprocName sprocCommand.Connection transaction.Connection..
C#/SQL - What's wrong with SqlDbType.Xml in procedures? http://stackoverflow.com/questions/574928/c-sql-whats-wrong-with-sqldbtype-xml-in-procedures int identity 1 1 primary key XmlText xml NOT NULL And the sproc CREATE PROCEDURE XmlTest_Insert @XmlText xml AS INSERT INTO..
Which ORM is the best when using Stored Procedures http://stackoverflow.com/questions/687762/which-orm-is-the-best-when-using-stored-procedures improve this question SubSonic has excellent support for sprocs. It will wrap each one in a helper method and you can retrieve.. show a way to do that in this blog post . As long as your sproc returns the same schema as SELECT FROM TableName would it will..
|