title: Linq to Sql : Database changes in a Visual Studio project
body: <p>I'm new to C# and Visual studio.I have the code for a C# Project on Visual Studio that is perfectly working. But, I need to make few changes to the database and code.Delete two columns - Col1,Col2 from Table A, add them to Table B and change the business logic accordingly . I have a .dbml file that defines the mapping between the database tables and the code. Is designer.cs files auto-generated from .dbml files while building the code ? If no, how do I generate these files ? If I were to delete the columns in Table - what are the corresponding files(dbml/designer.cs) I need to change ? This might be naive but, I'm not sure  how these files are connected to the database.</p>