The following are the steps to add ADO.NET Entity Data Model in ASP.NET Web API Application. We are adding ADO.NET Entity Data Model and using the Entity Framework Database First Approach we are going to communicate with the SQL Server database and will perform the CRUD Operations. At this point, you should have the ASP.NET Web API project created with the following file and folder structure. Once you click on the OK button, it will create the ASP.NET Web API Project. From this dialog, we are going to choose the Web API project template, select the Authentication type as No Authentication and then click on the OK button as shown in the below image. A new dialog window will open with the Name “ New ASP.NET Project” for selecting project Templates as per your requirement. Finally, click on the “ OK” button as shown in the below image. Open Visual Studio and select File – New – Project as shown belowįrom the “ New Project” window, select the Web option under the “ Visual C#” option which is under the “ Installed” section. Again from the middle pane, you need to select the “ ASP.NET Web Application” and n ame the project as “ EmployeeService“. INSERT INTO Employees VALUES ('Preetiranjan', 'Sahoo', 'Male', 80000) INSERT INTO Employees VALUES ('Hina', 'Sharma', 'Female', 35000) INSERT INTO Employees VALUES('Shudhansshu', 'Nayak', 'Male', 30000) INSERT INTO Employees VALUES ('Sandeep', 'Kiran', 'Male', 45000) INSERT INTO Employees VALUES ('Priyanka', 'Dewangan', 'Female', 30000) INSERT INTO Employees VALUES ('Shushanta', 'Jena', 'Male', 45000) INSERT INTO Employees VALUES ('Sambit', 'Mohanty', 'Male', 70000) INSERT INTO Employees VALUES ('Preety', 'Tiwari', 'Female', 45000) INSERT INTO Employees VALUES ('Anurag', 'Mohanty', 'Male', 45000) INSERT INTO Employees VALUES ('Pranaya', 'Rout', 'Male', 60000) Please use the following SQL Script to create the WEBAPI_DB database and Employees table and populate the Employees table with sample data.
#VISUAL STUDIO 2017 WEBSITE TUTORIAL HOW TO#
We are going to use the following Employees table in this demo to understand how to create ASP.NET Web API Application using SQL Server database. Example: ASP.NET Web API using SQL Server For example, you can even use raw ADO.NET. You can use any technology of your choice to retrieve data from the database.
We will be using Entity Framework Database First Approach to retrieve data from the SQL server database. The ASP.NET Web API EmployeeService that we are going to build will retrieve the data from the Employees database table. We are going to use this service as the base for understanding many of the ASP.NET Web API concepts that we are going to discuss in our upcoming articles. So here we will create the ASP.NET Web API Service which will perform the CRUD operation on the SQL Server database. In this article, I am going to discuss ASP.NET Web API using SQL Server. Data Structures and Algorithms Tutorials.
0 kommentar(er)
