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…
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…
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…
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 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…