Hi,
I am going to build a web application by using Webform, the back end data is SQL server data. I have two cases of connect data in SQL server.
1. In the web forms of my web project, as there are some dropdown list fields need to connect to the table data in SQL server, those data in SQL server are existed data can be accessed by Stored procedure,
2. As well, in my different web forms which accept user data entry, I also need to save those new created data to SQL server, those are the new tables in SQL server.
Now, my question is how to build the connection in the 2 cases above?
For case 1, should I create Entity Framework based on existing data(table)? and then use it in all my application (web forms)?
For case 2: should I create another Entity Framework based codes? or create new tables in SQL server then connect them?
I appreciate if anybody can provide any examples of how to achieve my goal,
...
Go to the complete details ...