DataJuggler.Net 5.6.0

When I updated earlier today I forgot to update the dependency for DataJuggler.Core.UltimateHelper to version 1.3.5.

Version 1.3.5 of Ultimate Helper includes a new EnvironmentVariableHelper.cs class.

// if the connectionName is set if (dataManager.HasConnectionName) { // Set the ConnectionString dataManager.DataConnector.ConnectionString = EnvironmentVariableHelper.GetEnvironmentVariableValue(dataManager.ConnectionName); }

This update was created so that DataTier.Net ( https://github.com/DataJuggler/DataTier.Net ) will with Dot Net Core / Blazor.

I started a full Dot Net Core version, but I wanted to have this version work for both.

To use DataJuggler.Net in Blazor, you must be using Visual Studio 16.3 Preview and Dot Net Core 3 preview and System.Data.SqlClient preview Version="4.7.0-preview8.19405.3" or higher. (I wasted a day until I figured this out by checking the 'Include Prerelease' checkbox in Nuget Package Manager for Visual Studio.

Also to use DataTier.Net in Dot Net Core / Blazor, Connection Strings are no longer able to be set in Web.config or App.config files, so now they are set in an Environment Variable.

When you create an instance of the Gateway, you must set the Connection Name to be the name of the Environment Variable that contains your connection string.

Edit Environment Variables I just learned how to use Environment Variables this week, but they are the easiest thing ever. In Windows 10 type Edit Environment Variables in the Search Box and click 'Set Environment Variables.'

Then create an instance of the Gateway like this:

// set the connectionName
string connectionName = "DataJugglerWebConnection";

// Create a new instance of a 'Gateway' object, and set the connectionName
Gateway gateway = new Gateway(connectionName);

// load the products
List<Product> products = gateway.LoadProducts();

I am building a new Data Juggler Website in Blazor and hope to have it live very soon. Blazor is awesome so far.