Universe Guide Blog Archive 2
How to create a CodeFirst Entity Framework Project using Visual Studio / 13th August 2022 12:14 PM
First steps in creating a CodeFirst Entity Framework application using .NET and Visual Studio 2019. Read More...
How to read a file using SQL in a SQL Server stored procedure / 11th August 2022 8:01 PM
Reading a file into SQL is simple, but it's not as straightforward as using a high-level language such as C#. There's no need to shell out for an external application. Read More...
How to test if a file exists in SQL Server / 10th August 2022 9:09 PM
Although SQL Server deals primarily in data, there are times when files need to accessed, this article describes how to test if the file exists or not. Read More...
How to count the number of distinct field values in a table in SQL Server / 22nd May 2022 10:36 AM
If you need to count the distinct number of values in a SQL Server table and the only way you can think of is a temporary table, there is an easier way. Read More...
How to do Case Sensitive Searches in SQL Server / 13th March 2022 1:17 PM
Searches in SQL Server are case sensitive but it is possible to carry out Case Sensitive searches using an additional command in the SQL and is very easy to understand. Read More...
How to write protect or unprotect a file using C# or VB.NET / 12th March 2022 7:46 PM
How to write protect a file so that it cannot be accidentally deleted. Examples in both C# and VB.NET on how to write protect and unprotect a file. Read More...
How to delete a folder and its contents using C# or VB.NET / 12th March 2022 7:09 PM
Deleting a folder and its contents is easy by using one line but what if you need to delete a folder which has write protected files in it as well. Read More...
How to shutdown or restart the computer using C# or VB.NET / 12th March 2022 6:04 PM
How to start shutdown or restart a PC using .NET without using any direct windows system calls. Example in both C# and VB.NET. Read More...
How to do Error Handling in Javascript / 10th March 2022 7:21 PM
A simple example of how to use structured error handling in Javascript. Read More...
How to generate a random number in .NET / 10th January 2022 6:28 PM
How to generate a random number in .NET. Its easy, you instantiate an object to generate the value now rather than using a language keyword. Read More...