Can we use MSSql as backend in asp.net...if yes then How.?



Can we use MSSql as backend in asp.net...if yes then How.?..

Answer / Jitendra Sharma

Yes, Microsoft SQL Server (MSSQL) can be used as a backend database for ASP.NET applications. The process typically involves connecting to the MSSQL database using ADO.NET or Entity Framework.nn1. Install .NET data providers for SQL Server:n- For ADO.NET, add `System.Data` and `System.Data.SqlClient` namespaces.n- For Entity Framework, install the EntityFramework NuGet package.n2. Configure a connection string in the web.config file or appsettings.json file to connect to the MSSQL database.n3. Use the ConnectionObject (ADO.NET) or DbContext (Entity Framework) to interact with the MSSQL database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

How do you add a javascript function for a link button in a datagrid ?

4 Answers   Microsoft,


What is the difference between CLICK and MOUSE DOWN Event ?

1 Answers   MCN Solutions,


what is the difference between response.write() and response.output.write()?

1 Answers  


When is an object collected by the Garbage Collector? [Four options were given]

1 Answers   ABC,


How to make paging concepts in datagrid in ASP.NET?

1 Answers   Sans Pareil IT Services,


What is the difference between a.Equals(b) and a == b?

4 Answers  


where can i gather the materials for MCP certification

3 Answers  


what is diffrent between asp & asp.net

2 Answers  


hi im shailendra singh my question is how we deploye the data base

3 Answers   HCL,


What is the size of Get method and how much data it can store?

1 Answers   HCL,


When Garbage Collector will run and how its identifing whether the Object is used or Not.?

2 Answers   Verizon,


Describe how passport authentication works.

1 Answers  


Categories