Send Alt-Control-Delete to a Windows server via Remote Desktop
When you log into a Windows server via the Remote Desktop Protocol (RDP) in some cases you need to send the Alt-Control-Delete ( in other notations Alt-Ctrl-Del, Control-Alt-Delete, Ctrl-Alt-Del ) key combination to the remote server. From a Macintosh…
Connect to a MySQL database from Visual Studio 2017
As of today weI can connect to a MySQL database, but cannot generate the Entity Data Model from a MySQL database in Visual Studio 2017 To access a MySQL database from Visual Studio 2017 IMPORTANT: First install MySQL for Visual Studio, and after that…
Generate Entity Framework Entity Data Model in Visual Studio 2017
Visual Studio 2017 has many project type options, and not all of them support the Entity Framework user interface to generate the Entity Framework Data Model (EDMX) file. If you create an ASP.NET Web Application(.NET Framework) you can add the EDMX file…
{“error”:”Entity type ‘AspNetUserRoles’ has composite primary key defined with data annotations. To set composite primary key, use fluent API.”}
When a database table has composite keys (multiple columns are in the key) you cannot use the usual key definition [Key] [Display(Name = “UserId”)] public string UserId { get; set; } [Key] [Display(Name = “RoleId”)] public string…
Remove the 2014 Honda CR-V EX center console
There is a great post at http://www.crvownersclub.com/forums/17-interior/152730-2014-center-console-removal.html on the steps to remove the center console of the 2014 Honda CR-V EX by Jepalan. I have copied his description and added my photos to help…
The ham radio restarts when the push to talk button is released
I have installed a new Kenwood TM-281A ham radio in my car. The power is filtered by a Kenwood PG-3B noise filter. When I opened the package of the noise filter, I have noticed some burnt smell but did not pay much attention. The radio transmitted…
Generate SQL script from Entity Framework migration script
It is not recommended to execute Entity Framework migration scripts in production, It is important that you execute all SQL steps manually on the production database section-by-section to immediately see the result and be able to recover in case a…
DbUpdateConcurrencyException: Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded.
The .NET Core Entity framework makes database access easy. When you auto-generate a Razor page in a .NET web application to edit a data row, the scaffolding places controls on the page for every column. There are columns in most of the tables that we…
Splunk App for AWS
To collect data from AWS install the Splunk App for AWS plugin. The app currently can collect information from AWS Config, Config Rules, CloudTrail, Inspector, CloudWatch, CloudWatch Logs, Billing, S3, Kinesis, Metadata. New data source To set up a new…
Skip steps in an InSpec integration test based on Chef attribute values
To speed up the test of some complex recipes, I use an attribute to skip certain long-running installations when I only need to test the rest of the recipe. We will pass Chef Attribute values into an InSpec test using environment variables. Declare an…