Inserting and Deleting records in a database using LINQ to SQL is just as easy as selecting information. What’s not so easy is actually finding out how to do it. There are lots of excellent blog posts around such as this one by Scott Guthrie http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx, however most of them we’re all written for the [...]
Archive for the ‘SQL Server’ Category
LINQ to SQL Inserts and Deletes
Posted in .NET, LINQ to SQL, SQL Server, Web Development, tagged .NET, C#, Database, Delete, Insert, LINQ to SQL, SQL Server on July 18, 2010 | Leave a Comment »
LINQ to SQL Connection Strings
Posted in .NET, LINQ to SQL, SQL Server, Visual Studio, Web Development, tagged .NET, Class Library, Connection Strings, LINQ to SQL on June 23, 2010 | Leave a Comment »
LINQ to SQL is great but like all great things at some point it does something that you don’t expect and gives you a headache. An example of this happened to me this week with the differences between how connection strings are handeled when you LINQ to SQL model is in a class library rather [...]
How to search inside Stored Procedures?
Posted in SQL Server, tagged SQL Server, Stored Procedures on August 31, 2009 | Leave a Comment »
A common problem faced by many developers when it comes to databases and SQL Server is how to search the text inside a stored procedure. In many systems particularly older Classic ASP solutions, functional code has been moved from the actual application to stored procedures inside the database. This is usually because it will either [...]
