<rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>How Do I: LINQ to SQL: Updating with Stored Procedures</title><link>http://asp.net</link><pubDate>Mon, 06 Sep 2010 20:55:54 GMT</pubDate><generator>umbraco</generator><description>Comments for How Do I: LINQ to SQL: Updating with Stored Procedures</description><language>en</language><atom:link href="http://asp.net/rss/comments/37520" rel="self" type="application/rss+xml" /><item><title>Comment Posted by chenyaping034</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Fri, 14 Mar 2008 10:02:08 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006844</guid><description><![CDATA[ <p>I like the video!I wish more and more the good video about the konwledge of LINQ</p>]]></description><enclosure length="0" type="image/png" url="http://i2.asp.net/avatar/chenyaping034.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by Lee Dumond</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Tue, 08 Apr 2008 13:35:32 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006845</guid><description><![CDATA[ <p>Just would like to point out a couple of errors in the code:</p> <p>In part9.aspx, line 31:</p> <p>Product p = db.Products.Single(p =&gt; p.ProductName == &quot;Foo&quot;);</p> <p>You can&#39;t declare a local variable &quot;p&quot; in the lambda expression here, because &quot;p&quot; is already used to denote the Product. You could change it to something else, like:</p> <p>Product p = db.Products.Single(prod =&gt; prod.ProductName == &quot;Foo&quot;);</p> <p>In Helpers.cs, line 57:</p> <p>return ExecuteCommand(&quot;delete from products where ProductId={0}&quot;, instance.ProductID);</p> <p>DeleteProduct is a void method, so it can&#39;t return anything. &#160;You need to get rid of the &quot;return&quot; keyword.</p>]]></description><enclosure length="0" type="image/png" url="http://i3.asp.net/avatar/Lee%20Dumond.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by LoftenPierce</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Mon, 21 Apr 2008 15:17:19 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006846</guid><description><![CDATA[ <p>I have a question: &#160;I want to be able to leverage my code to use LinQ to sql. &#160;We have a DAL generator that creates our sprocs from out tables. &#160;As such, we include the CRUD sql code in the sproc, using an &quot;Action&quot; parameter, which tells which sql code to run (0=read, 1=create, 2=update, and 3=delete). &#160;I&#39;ve been trying to get linq to work with this model. &#160;How do I get linq to use the parms that I want and ignore the rest? Here&#39;s how I get it to work now: </p> <p> &#160; &#160; &#160; &#160;Dim db As New MOCDataContext</p> <p> &#160; &#160; &#160; &#160;Dim q = db.SProc_MOCT_CC(0, Nothing, Nothing, Nothing, Nothing, Nothing)</p> <p> &#160; &#160; &#160; &#160;GridView1.DataSource = q</p> <p> &#160; &#160; &#160; &#160;GridView1.DataBind()</p> <p>The first parm is the action, the rest I set to use &#39;Nothing&#39; to ignore the other parms. &#160;Normally, I would just pass the parms I wanted the 2nd or third parms I would fill in (via class properties) and leave the others. &#160;How can I get around this? &#160;Am I making sense?</p>]]></description><enclosure length="0" type="image/png" url="http://i1.asp.net/avatar/LoftenPierce.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by cv_vikram</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Mon, 18 Aug 2008 10:55:58 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006847</guid><description><![CDATA[ <p>thanks...</p>]]></description><enclosure length="0" type="image/png" url="http://i2.asp.net/avatar/cv_vikram.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by TheDirtyBird</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Thu, 21 Aug 2008 14:11:00 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006848</guid><description><![CDATA[ <p>Could you please post a link where I can download this video?</p>]]></description><enclosure length="0" type="image/png" url="http://i2.asp.net/avatar/TheDirtyBird.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by noonway</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Tue, 02 Sep 2008 13:46:46 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006849</guid><description><![CDATA[ <p>Ditto... Could use the download link, please.</p>]]></description><enclosure length="0" type="image/png" url="http://i3.asp.net/avatar/noonway.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by jdubman</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Fri, 03 Oct 2008 02:48:05 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006850</guid><description><![CDATA[ <p>Indeed, the Linq videos up to this point are available for download, but videos 8 and 9 are not. These videos are a great learning tool and I would love to download all of them and watch them offline. It would make things even easier if there were a single ZIP download that combines them all. Thanks!</p>]]></description><enclosure length="0" type="image/png" url="http://i2.asp.net/avatar/jdubman.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by mufasa8005</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Thu, 09 Oct 2008 04:34:32 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006851</guid><description><![CDATA[ <p>Yeah, a link for download will be much appreciated. Thanks for your assistance in these videos.</p>]]></description><enclosure length="0" type="image/png" url="http://i2.asp.net/avatar/mufasa8005.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by djibril_chimere_DIAW</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Fri, 24 Oct 2008 08:07:47 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006852</guid><description><![CDATA[ <p>Thanks! J&#235;r&#235;j&#235;f!</p>]]></description><enclosure length="0" type="image/png" url="http://i1.asp.net/avatar/djibril_chimere_DIAW.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by rami_nassar</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Sun, 04 Jan 2009 07:10:52 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006853</guid><description><![CDATA[ <p>thanks scott, interesting and helpful video taturial</p>]]></description><enclosure length="0" type="image/png" url="http://i2.asp.net/avatar/rami_nassar.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by acteh11</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Tue, 06 Jan 2009 20:26:11 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006854</guid><description><![CDATA[ <p>&lt;a rel=&quot;nofollow&quot; target=&quot;_new&quot; href=&quot;http://download.microsoft.com/download/b/a/2/ba27fc07-239d-4f67-b47b-543378ae0016/WinVideo-stanfield-linq-to-sql-part8.wmv&quot;&gt;download.microsoft.com/.../WinVideo-stanfield-linq-to-sql-part8.wmv&lt;/a&gt; is not available. &#160;Please check.</p>]]></description><enclosure length="0" type="image/png" url="http://i1.asp.net/avatar/acteh11.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by Gery128</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Tue, 17 Nov 2009 09:13:09 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006855</guid><description><![CDATA[ <p>Video Download link not working. posts back the page to itself.</p><p>where do i get the video?</p>]]></description><enclosure length="0" type="image/png" url="http://i1.asp.net/avatar/Gery128.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by tmorton</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Tue, 17 Nov 2009 12:33:00 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006856</guid><description><![CDATA[ <p>The video link is <a rel="nofollow" href="http://download.microsoft.com/download/b/a/2/ba27fc07-239d-4f67-b47b-543378ae0016/WinVideo-stanfield-linq-to-sql-part8.zip." target="_blank">download.microsoft.com/</a>  The video has been updated accordingly.</p>]]></description><enclosure length="0" type="image/png" url="http://i3.asp.net/avatar/tmorton.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by juan.toris</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Wed, 25 Nov 2009 00:47:28 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006857</guid><description><![CDATA[ <p>Excelent video. LINQ functionality look very well.</p><p>But!!!!</p><p>I try to adapt one VIEW from SQL to LINQ object and it don&#39;t work. After it, I use the TABLE and STOREPROCEDURE to save data but I need to pass a parameter manual to SP to indicate that it is an update. So, I can find how pass throught LINQdatasource the value for this parameter.</p>]]></description><enclosure length="0" type="image/png" url="http://i3.asp.net/avatar/juan.toris.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by dpeterman</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Thu, 28 Jan 2010 16:36:31 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006858</guid><description><![CDATA[ <p>Great video. The examples of how VI can be helpful was fantastic. Maybe you should make a video on that next time.</p>]]></description><enclosure length="0" type="image/png" url="http://i3.asp.net/avatar/dpeterman.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by vvvvvdev</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Tue, 20 Apr 2010 08:59:19 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-000000006859</guid><description><![CDATA[ <p>what a terrific job !!!! </p>]]></description><enclosure length="0" type="image/png" url="http://i3.asp.net/avatar/vvvvvdev.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item><item><title>Comment Posted by matt.g</title><link>http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-with-stored-procedures</link><pubDate>Mon, 06 Sep 2010 20:55:54 GMT</pubDate><guid isPermaLink="false">00000000-0000-0000-0000000010141</guid><description><![CDATA[ <p>A video on LINQ to SQL Batch Updates would be useful. </p>]]></description><enclosure length="0" type="image/png" url="http://i3.asp.net/avatar/matt.g.jpg?forceidenticon=false&amp;dt=635047452600000000&amp;enableAvatar=False&amp;cdn_id=2013-05-10-001" /></item></channel></rss>