You must Sign In to post a response.
  • Category: LINQ

    How to update DBML Programmatically

    Are you looking for a way to update DBML Programmatically ? then read this thread to know more about it

    Hi ,

    I am using DBML in my project the file contains many tables and views.if i add new column into my sql table that should be reflect in my DBML automatically.

    Thanks in Advance.
  • #748064
    If you have added any column in the database table then in order to update the dbml file. Right Click the table in the dbml file designer(*.dbml file) -> Then Choose Add Property -> give some name to the property. This is the new column which you have added to the table in the database. You can then select this column and Press F4 to go to the properties window of this column and set its other properties such as its datatype, Nullable, Primary Key, Read Only and so on.
    Miss. Jain
    Microsoft Certified Technology Specialist in .Net

  • #748105
    follow below link, will give you step by step details


  • #748223
    Hi Vijai :

    One other way is to delete the table from the DBML file and add it again from the Server explorer.
    This way the latest column properties are imported for the table after adding (or) changing any column in database.

    Vignesh Kannan

  • Sign In to post your comments