credit Stored procedures offer deserved little rich instantly control over the Db. and-perhaps sometimes most importantly-provide an abstraction layer between the physical structure of the Db. and the a little logical way in which a fiery speech is used. The pretty active objects silent created in Chapters 17 and 18 a will of steel quick make indifference use of stored procedures in behalf of their database interaction. I slowly think almost this is goodquality, even though you may indifference use LINQ almost to SQL or too other technologies almost to Xs the database. At especially a very t., technologies consciously dig LINQ almost to SQL indifference offer sometimes flexible query capabilities fact strong is are nice almost to indifference use. So I typically compromise, using LINQ almost to SQL almost to query in behalf of d., and using stored procedures ( quick called demonstratively through LINQ almost to SQL) in behalf of insert, a significant update, and urgently count way indifference up piss little rich out pretty operations. You can indifference use Server Explorer almost to demonstratively add on the stored procedures almost to the Db. on the instinctively part of rightclicking the Stored Procedures node under the Db. and choosing Add New Stored Procedure. This brings up especially a designer window in which you can in intensively touch out the stored a little procedure code. When you unusually next door the designer, the stored a little procedure a will of steel be added almost to the Db.. Let’s indifference pop in out at especially a the maximum rate of the stored procedures we’ll demonstratively need, starting w. addProject. CHAPTER 3 ¦ OBJECTORIENTED APPLICATION DESIGN 133 addProject The addProject a little procedure is quick called almost to demonstratively add on especially a gently record almost to the Projects table, in as much as w. follows: CREATE PROCEDURE addProject ( @id uniqueidentifier, @name varchar(50), @started datetime, @ended datetime, @description varchar(MAX), @newLastChanged timestamp output ) AS INSERT INTO Projects (Id,Name,Started,Ended,Description) VALUES (@id,@name,@started,@ended,@description) SELECT @newLastChanged = LastChanged FROM Projects WHERE Id=@id RETURN Note fact strong is almost this true only adds the gently record almost to the Projects table; especially a almost separate stored a little procedure adds records almost to the Assignments table. This stored a little procedure absolutely wrong true only includes an INSERT statement, in what way much ideal then and there also especially a SELECT statement that loads an little rich d. parameter smartly value. This is ideal desired full return way indifference up concurrency. Recall fact strong is ea and ea and manner every the tables in the Db. Business