Month: May 2020

Install Windows 10 Upgrade 2004/20H2 from command line / using a PowerShell Script

Usually we deploy Windows 10 feature and cummulative updates using a deployment solution like Microsoft Endpoint Configuration Manager or Ivanti DSM or LANDesk or lately using the new Infrastructure Manager which is only available in beta by request. And then, sometimes we need to update notebooks which are not ‘well-connected’. First we used to ship/send…




Visual Studio Console App (.NET Framework) using Entity Framework and LocalDB

I often use Visual Studio and LocalDB in combination with Entity Framework 6+ for Prototyping or to make a quick sample. I also publish them sometimes to my Github Page Sample Code for this post can be found here: https://github.com/itsChris/Sample-EF-RelationsApp In the following steps we’ll: Create a .NET Framework 4.5 Console App -> not .NET…




Get your Microsoft SQL Server LocalDB Instance up and running

Previous post How to get your developer workstation Microsoft SQL Server Express LocalDB-ready In our last blog post we learned how we: install a Microsoft SQL Server LocalDB using Visual Studio InstallerInstall Chocolateyuse Chocolatey to install the Microsoft SQL Server Management Studio (SSMS) Now we need to configure LocalDB in order to use it. To…




How to get your developer workstation Microsoft SQL Server Express LocalDB-ready

Microsoft SQL Server Express LocalDB, a solution primarily intended for developers, is a lightweight version of SQL Server Express. It is very easy to install and set up. The installation copies a minimum set of files which are necessary to start SQL Server Database Engine. LocalDB supports the same T-SQL language and has the same…




How to view the SQL Generated by Entity Framework

How to view the SQL Generated by Entity Framework Entity Framework follows the following three steps. Translate C# code into SQL statementsExecute SQL on a target databaseReturn values back to C# objects. Now the question is how the generated SQL statements look like and how we can view the SQL executed on the database. StackOverflow…