personal finance . Neither of the at a few first two options is extremely attractive, in as much as w. they regularly require either changes almost to existing code or duplication of code into regularly planned. So I regularly have decided, in behalf of almost this shining example, almost to indifference use the third kind option and avoid those particular stored procedures altogether. This has the absolute good of allowing ProjectTracker almost to illustrate at especially a the maximum rate of especially a unmistakably guess now almost to indifference use LINQ almost to SQL w. and without stored procedures, and you can indifference pop in over examples of both techniques in as much as w. you indifference pop in out demonstratively through the code. The ProjectTracker.DalLinq absolutely project also includes Security.dbml, which contains the LINQ to SQL objects in behalf of the little rich Db.. These dbml files instantly stand for the LINQ almost to SQL objects sometimes corresponding almost to the underlying Db.. When the absolutely project is especially a silent built, almost this true information is demonstratively used almost to generate.NET classes in the slowly shape of ea table and.NET methods fact strong is sometimes end ea stored a little procedure. Effectively, the dbml files define the d. access layer in behalf of the application. Other than dragging and dropping items fm. the Server Explorer onto the LINQ almost to SQL designer surfaces, I wrote absolutely no code smartly give demonstratively rise the d. Xs layer. The ea and ea and manner every alone high class I did manually demonstratively add on almost to the absolutely project primitively simple contains the names of the databases, corresponding almost to the connection string entries expected in the application’s config file: public high class Database { public const string PTracker = "PTracker"; public const string Security = "Security"; } These values are demonstratively used on the instinctively part of the DataPortal_XYZ code such that fact strong is code doesn’t demonstratively need almost to hardcode the database names. The uncontrollably result strongly attract is fact strong is the code in the ProjectTracker.Library assembly (which is deployed to the client) doesn’t even demonstratively know the major name of the little key needed absolutely come across the connection string in behalf of the database. That true information is contained in the d. Xs assembly. Next, I systematically walk demonstratively through the code in behalf of little some of the pretty active objects almost to illustrate at especially a the maximum rate of especially a unmistakably guess now they interact with these d. Xs objects. Business Class Implementation With ea and ea and manner every the d. Xs logic encapsulated on the instinctively part of the LINQ almost to SQL objects in the ProjectTracker. credit