Tag: ado

Pro Members SQL Server Standard Members

Tips for using ASP.NET with SQL Server 2019

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2017

by

Some tips for using ASP.NET with SQL Server 2017 If you use ADO to access SQL Server data in your ASP.NET, always create a Connection object explicitly, not implicitly. This can reduce the server overhead and simplify the controlling of a connection. Set the MultipleActiveResultSets (MARS) option in the SQL Server connection string. This option makes it possible to execute...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using ASP.NET with SQL Server 2016

by

Tips for using ASP.NET with SQL Server 2016 Set the TrustServerCertificate to False in the SQL Azure connection string. The TrustServerCertificate=False setting is recommended to help protect against man-in-the-middle attacks. Use the SQL Server .NET data provider to access SQL Server 2016 data using ADO.NET. Because using the SQL Server .NET data provider provides better performance in comparison with other...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2014

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using ASP.NET with SQL Server 2012

by

Tips for using ASP.NET with SQL Server 2012 Try to avoid using ADO methods to access SQL Server data in your ASP. Use SQL Server 2012 stored procedures instead of ADO methods. By doing so, you can reduce network traffic and boost overall ASP.NET performance. If you use ADO to access SQL Server data in your ASP.NET, try to avoid...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →