When I make a database change, how do I know what needs to be removed and readded to the LinqToSql O

Posted by Michael Maddox on Stack Overflow See other posts from Stack Overflow or by Michael Maddox
Published on 2009-06-05T14:24:06Z Indexed on 2010/03/31 22:03 UTC
Read the original article Hit count: 377

Filed under:

linq-to-sql

|

visual-studio-2008

|

dbml

|

sqlmetal

For example, I alter a column in a table to be not null from null.

I need to then delete and readd the table. That part is pretty clear.

What about views, functions, and stored procedures that access the table, especially that column in the table?

I've tried running diffs against the files generated by SQLMetal with some limited success, but even with that it's fairly unclear.

I know there is at least one commercial tool out there that claims to address this problem, but I am looking for something free.

How are people dealing with this issue?

© Stack Overflow or respective owner

Related posts about linq-to-sql

how can i page my linq to sql result set

as seen on Stack Overflow - Search for 'Stack Overflow'
Remembering MySQL could use the instruction "limit" to indicate where I was starting my result set and how many wanted to have included. Select * FROM Users Limit [start], [Length] How can I do this in LinqToSql >>> More
LINQ to SQL and missing Many to Many EntityRefs

as seen on West-Wind - Search for 'West-Wind'
Ran into an odd behavior today with a many to many mapping of one of my tables in LINQ to SQL. Many to many mappings aren’t transparent in LINQ to SQL and it maps the link table the same way the SQL schema has it when creating one. In other words LINQ to SQL isn’t smart about many to many mappings… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
LINQ to SQL Profiler

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this article we will be taking a look at the new LINQ to SQL Profiler from HibernatingRhinos. This tool gives you a view into the goings on of LINQ to SQL. Not only does it allow you to see the SQL that is generated by your LINQ queries but it also shows you information about your connections… >>> More

Related posts about visual-studio-2008

Server.transfer causing HttpException

as seen on Stack Overflow - Search for 'Stack Overflow'
I am developing a C#/SQL ASP.NET web application in VS 2008. Currently I am using the Server.Transfer method to transfer control from one ASPX.CS file to another ASPX file. The first time through, this works. But after control is transferred to this new file it encounters a condition: if (restart… >>> More
Using Visual Studio 2008 to Assemble, Link, Debug, and Execute MASM 6.11 Assembly Code

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to use Visual Studio 2008 to the greatest extent possible while effectively compiling/linking/building/etc code as if all these build processes were being done by the tools provided with MASM 6.11. The exact version of MASM does not matter, so long as it's within the 6.x range, as that… >>> More
Missing help files for Microsoft.WindowsMobile in Visual Studio 2008 help system

as seen on Stack Overflow - Search for 'Stack Overflow'
I've just installed the Windows Mobile 6.5.3 DTK, both standard and professional. Before that I had the standard and professional Windows Mobile 6 SDKs. All Windows Mobile help pages are missing in Visual Studio 2008's help system - in particular everything in the Microsoft.WindowsMobile namespace… >>> More
Visual Studio 2008: Don't deploy SQL Server Compact 3.5 when debugging

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using VS2008 to create a Compact Framework application for a Windows CE 5.0 device (Datalogic Kyman). I'm using SQL Server Compact 3.5 in my application. However, I'm debugging on a Kyman that still has Windows CE 4.2 installed (attached via USB using Mobile Device Center). My problem: VS2008… >>> More
Visual Studio 2008: Start custom build target via project/solution context menu - without add-in

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a custom build target in a visual studio 2008 c# project. Is there a simple way to add a context menu item to the project, so that the custom build target can be executed via the ide? The build target is not integrated into the default build process and has to be started by hand. This step… >>> More