Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. LINQ
  4. Database Changes - how to update DBML

Database Changes - how to update DBML

Scheduled Pinned Locked Moved LINQ
databasequestionsql-serversysadmintutorial
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Steve van Niman
    wrote on last edited by
    #1

    I've added a column to my SQL Server database. How do I get the existing .dbml's to recognize the new column in my project? Is there a way to refresh? Or is it delete and add again? Or is it manual changes to the code? Many Thanks!

    A L 2 Replies Last reply
    0
    • S Steve van Niman

      I've added a column to my SQL Server database. How do I get the existing .dbml's to recognize the new column in my project? Is there a way to refresh? Or is it delete and add again? Or is it manual changes to the code? Many Thanks!

      A Offline
      A Offline
      Arun Jacob
      wrote on last edited by
      #2

      Hope this'll help, http://social.msdn.microsoft.com/Forums/en-US/linqprojectgeneral/thread/f032d242-6dfa-4a99-8368-b3a0e3393679[^] :)

      Arun Jacob http://codepronet.blogspot.com/

      S 1 Reply Last reply
      0
      • A Arun Jacob

        Hope this'll help, http://social.msdn.microsoft.com/Forums/en-US/linqprojectgeneral/thread/f032d242-6dfa-4a99-8368-b3a0e3393679[^] :)

        Arun Jacob http://codepronet.blogspot.com/

        S Offline
        S Offline
        Steve van Niman
        wrote on last edited by
        #3

        Spot on! Thanks for the link.

        1 Reply Last reply
        0
        • S Steve van Niman

          I've added a column to my SQL Server database. How do I get the existing .dbml's to recognize the new column in my project? Is there a way to refresh? Or is it delete and add again? Or is it manual changes to the code? Many Thanks!

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          If you change your table in the database you should delete the corresponding table from dbml file and add it again and the dbml file regenerate again after refreshing the server connection, so your changes take effect.

          Thanks and Regards Sujit Kr. Mandal Software Engineer

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups