Dbml file not returning data.My page is unable to display any data from the dbml file using a stored procedure.

Question

Hi,

I have a table that supposed to get data from a dbml file using stored procedure but currently no data is being pulled through. (ASP.net c#)

Answer 1

DBML, so you are using Linq?
See How to: Call a Stored Procedure by Using LINQ (Visual Basic) for all steps.

Answer 2

Hi @Lerato_Dev ,
If you add any new stored procedures or update any stored procedures, you should open Server Explorer from the view. there it will list the db connections. there right click on that particular connection which points to your database and refresh. It will update automatically.

To implement a LINQ to SQL application, you can follow the steps described in the documentation. Please note that many steps are optional.
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/typical-steps-for-using-linq-to-sql
Best regards,
Lan Huang

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.