Tips for using ASP.NET with SQL Server 2019 Use the SQL Server .NET data provider to access SQL Server 2019 data using ADO.NET. Because using the SQL Server .NET data provider provides better performance in comparison with other providers, you should use the SQL Server .NET data provider whenever possible. Try to avoid synchronous calling when developing ASP.NET applications. Synchronous...
Tag: recordset
Some tips for using ASP.NET with SQL Server 2014
Some tips for using ASP.NET with SQL Server 2014 If you use ADO to access SQL Server data in your ASP.NET, avoid creating transactions using ADO methods. Try to create transactions inside a stored procedure on the SQL Server. By doing so, you can reduce network traffic and boost overall ASP.NET performance. When building a web page based on SQL...