.NET & SQL Development Guide
How to replace the first occurrence in a string in SQL Server / 14th April 2024 2:33 PM
Replace command in SQL will always replace all occurrences, but there are times when you only need to replace the first occurrence. This document will show you how to do just the first one. Read More...
What is an orphan web page? / 11th June 2023 10:09 PM
Orphan pages are a term used in SEO that describes a certain type of page within a website. Read More...
How to set the default database for SQL Server when you log in / 5th June 2023 9:10 PM
When you are using one database in SQL Server, it can be annoyance to always change the default database from master. There is a way to reolve the issue. Read More...
How to copy the current URL to the clipboard in Javascript / 4th June 2023 10:48 PM
How to copy the current URL in a browser to the clipboard for pasting elsewhere. Read More...
How to get the Month, Year or Day from a DateTime field in SQL / 29th May 2023 3:51 PM
How to get the month, year or any other part of a datetime field with ease. You can split the date time but there is an easier way to do things. Read More...
How to disable and enable a table trigger in SQL Server / 27th September 2022 9:08 PM
How to enable or disable a trigger on a SQL Server database is very easy to do, you just need to know the table and the trigger name in order to disable it. Read More...
How to use Database Transactions with .NET CodeFirst Entity Framework / 14th August 2022 1:35 PM
Transactions in .NET CodeFirst are as easy as they used to be when we weren't using Entity Framework. All you need to do is to create a transaction object and then commit or rollback as before. Read More...
How to delete a record using .NET CodeFirst Entity Framework / 14th August 2022 1:07 PM
Deleting a record using CodeFirst Entity Framework is a relatively easy method which essentially requires you to just set an object, change state and then save the record. Read on to find out more. Read More...
How to amend a record using CodeFirst Entity Framework .NET / 13th August 2022 6:12 PM
Creating and saving a record in CodeFirst .NET requires you first to fetch the object, edit and then save. Read more on how this is put into practice. Read More...
Example application using .NET Entity Framework / 13th August 2022 3:15 PM
Example application showing how you create a record in the database using C# .NET core Entity framework. Read More...