SQL Server has 2 operators called Union All and Union that combine the result-set of two or more SELECT statements. The difference between Union All and Union operators is that Union All will ‘not remove the duplicate rows’ from the combined result-set, on the other hand Union operator will ‘remove the duplicate rows’ from the combined result-set. (more…)
Certificate-based Authentication is the use of a Digital Certificate to identify a client request before granting it the access to a resource, network, application, etc. Certificate Authentication provides added security to web applications. You can easily implement it in ASP.NET Core 3.0. Let us understand how to do it.(more…)
You can install free SSL on both cPanel & Plesk control panels.
This method works on every hosting like GoDaddy, HostGator, Linux, Windows, etc.
The best part?
You will get the SSL Certificate from Let’s Encrypt free of charge at the very same instance.
Serverspace offers high-quality VPS/VDS services at affordable prices. Our cloud servers are easy to use via your personal account. We offer 24/7 support. Our staff is highly experienced in virtualized systems and aim to deliver the best possible performance for a VPS service. We strive to offer VPS services at the best possible prices, without cutting down on the quality. (more…)
In cases where you need to inserts lots of records into the database, eg 1 million records, then ADO.NET has a class called SqlBulkCopy which does this work very quickly. (more…)
When performing an ADO.NET operation you can sometimes get some exception like: 1. Database connection error – due to wrong connection string. 2. Operation timeout error – due to some network error. (more…)
Previously I taught how to Update Records using ADO.NET in ASP.NET Core Application. Now it’s time to make the final functionality which is the Delete Record feature. Like the update feature, in the delete feature to - there will be a new added column called Delete in the HTML table of the Index View. (more…)
I should also have the Update Inventory feature in my project. With this feature I will have the power to update any previously created Inventory records. Like, I can update the Name, Price and Quantity of a record that I want. (more…)
I will now create Read operation in ADO.NET to display all inventory records in the View. I will use SqlDataReader object for implementing this operation. (more…)