Knowledge Base for IT Professionals, Teachers and Astronauts
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 install MySQL Connector/Net. If MySQL Connector/Net is already installed on your workstation, uninstall …
Continue reading “Connect to a MySQL database from 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 to it. The .NET Core projects do not support the Entity Framework Data Model …
Continue reading “Generate Entity Framework Entity Data Model in Visual Studio 2017”
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 RoleId { get; set; } When you run the application you get the error message: {“error”:”Entity type ‘AspNetUserRoles’ has composite …
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 others in the process. This is in a 2014 CRV EX that does NOT have NAV, Heated Seats, Factory Amp, or Rear Entertainment …
Continue reading “Remove the 2014 Honda CR-V EX center console”
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 perfectly, but when I released the push to talk button, the …
Continue reading “The ham radio restarts when the push to talk button is released”
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 destructive action goes wrong. The Visual Studio .NET application templates contain Entity Framework migration scripts to …
Continue reading “Generate SQL script from Entity Framework migration script”
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 don’t want to display or edit, like keys, checksums, password …
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 data source, click the Set up button Already set up data source To add a …
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 attribute in the atrributes.rb file with a safe default value, to allow the …
Continue reading “Skip steps in an InSpec integration test based on Chef attribute values”
When you add a dependency reference to a Java project, it may compile without any errors, but runtime you may get an error message similar to this: HTTP Status 500 – Internal Server Error Type Exception Report Message An exception occurred processing JSP page [/index.jsp] at line [1] Description The server encountered an unexpected condition …
Continue reading “java.lang.NoClassDefFoundError, java.lang.ClassNotFoundException”