How do I generate a dbml file?

  • How do I generate a dbml file?

    In a Visual Studio file, A project contains a DBML file that, when opened, shows a very cool representation graphical of a database and all the interconnections between the tables.

    I want that for another project for documentation purposes. The database already exists. So how do I get from the sql server database with all the key relationships and the proverbial whole nine yards to the cool graphic representation of ta DBML file as seen in visual studio.

    I did some searching on the internet with several search engines and so far everything I see is working in the other direction such as "create database from DBML file? "

    It seems to have something to do with LINQ but I have yet to find an explanation about this.

  • In SSMS you can create a Database Diagram. I don't know if this is as complete as a DBML file, but it can give you a start.

    Open SSMS

    Expand the Databases tree in Object Explorer

    Expand the requested database tree

    Expand the Database Diagrams tree

    Acknowledge the message to create additional objects

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply