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.
To add stored procedures to the O/R Designer dbml file that you added earlier. Click the Sales by Year stored procedure and drag it to the right pane of the designer. Click the Ten Most Expensive Products stored procedure drag it to the right pane of the designer. Save your changes and close the designer.
dbml file will be added under App_Code folder. Expand Server Explorer and Right click on the Data Connections and select the option Add Connection. Add Connection Pop up will be opened, give the SQL Server details and select the then click on OK button. Database will be added under Data Connections as shown below.
Is there a way I can refresh the dbml file or do I have to delete it and generate a whole new one?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With