Category: Database

Mar 12 2021 March 12, 2021 March 12, 2021 NoComment by Christian Casutt

How to view/inspect the generated SQL by Entity Framework Core using .NET Core’s build-in logging

Posted in , , , ,

Referring: https://docs.microsoft.com/en-us/aspnet/core/fundamentals/logging/?view=aspnetcore-5.0 This blog post is about how to view the SQL generated by Entity Framework Core. This method uses Microsoft’s built-in logging for .NET Core. This method is an alternative to profiling the SQL with something like SQL Server Management Studio. This will work with an ASP.NET Core application, which should cover the vast…

Read More

Mar 05 2021 March 5, 2021 March 5, 2021 NoComment by Christian Casutt

Publishing an ASP.NET Core Web Application to IIS using Visual Studio 2019

Posted in , ,

I’m a developer at heart, so I’m constantly keeping up with the latest technologies. currently I’m developing ‘Time and Bill’, an ASP.NET Core Web Application. The application is based on Microsoft .NET Core 5.0 (5.03 to be exact). Well, developing the application is one thing, the other thing is to publish the application on an…

Read More

Jun 08 2020 June 8, 2020 June 9, 2020 NoComment by Christian Casutt

WSUS Windows Update Error 0x80244010

Posted in ,

Several Windows Server reported this Solution was connecting to SUSDB using Servername: np:\.\pipe\MICROSOFT##WID\tsql\queryStart SQL Server Management Studio elevated or get a Login failed for user Then query for the current value of MaxXMLPerRequest in table tbConfigurationC USE SUSDB GO SELECT MaxXMLPerRequest from tbConfigurationC Then update the value: UPDATE tbConfigurationC SET MaxXMLPerRequest = 0 And check…

Read More

Tags:

Jun 08 2020 June 8, 2020 June 8, 2020 1Comment by Christian Casutt

Accessing SUSDB (Windows Server Update Services – WSUS) WID Windows Internal Database -> Login failed for user

Posted in ,

SQL Server Management Studio installed, tried to connect to a SUS WID using Servername: np:\\.\pipe\MICROSOFT##WID\tsql\query Resulted in: =================================== Cannot connect to np:\\.\pipe\MICROSOFT##WID\tsql\query. =================================== Login failed for user ‘REMOVED\admin.solvia’. (.Net SqlClient Data Provider) —————————— For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476 —————————— Server Name: np:\\.\pipe\MICROSOFT##WID\tsql\query Error Number: 18456 Severity: 14 State: 1 Line Number: 65536 —————————— Program Location: at…

Read More

Jun 06 2020 June 6, 2020 June 6, 2020 NoComment by Christian Casutt

actiTIME time reporting – MySql data and reporting

Posted in , , ,

We’re using actiTIME (free version) for several years now. We’re happy with this time reporting/tracking solution, the only short coming for us are the integrated reports/the possibilities to create custom reports. In this article we’re going to Get an overview of actiTIME and database componentsGet access to the databaseCapture queries made by the actiTIME application…

Read More

Tags:

May 25 2020 May 25, 2020 May 25, 2020 NoComment by Christian Casutt

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

Posted in , , , , , , ,

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…

Read More

Tags:

May 24 2020 May 24, 2020 May 25, 2020 2Comments by Christian Casutt

Get your Microsoft SQL Server LocalDB Instance up and running

Posted in , , , ,

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…

Read More

Tags: