Skip to content

v5.0.2
Compare
Choose a tag to compare
@DataJuggler DataJuggler released this 24 Nov 14:33
· 22 commits to master since this release
v5.0.2
136f946

Big Update. DataTier.NET now targets .NET 9.

New project templates have been created for .NET 9 also.

Message Boxes have been replaced by a Message Display Control, making screen messages look a little nicer and without a loud noise while recording.

Note: The Blazor Data Services Control has been removed. It was a neat feature, but I realized I had not used it in all of .NET 8, so I just removed the code for the Blazor Data Services Control and related changes to the Project Editor.

The database no longer has these fields, so you must use the new database in the Database Folder of this project.

Version 2 Templates are the only templates going forward, so all new projects will only have two projects in the Data Tier.

  1. Data Access Component
  2. Object Library

Existing Projects or new projects for .NET 8 or lower will still work. It is recommended to use .NET 9 for all new projects.
All new development will be for .NET 9 unless a major bug is found in an earlier version.

Existing Users - Breaking Database Changes
The database has changed. In the Project Table, you can drop the columns:

  1. Enable Blazor Features
  2. Services Folder

Update the Stored Procedures from the file DataTier.NET.Database.sql, located in the Databasebase\SQLScripts folder of this repo.

Last Breaking Change Is All New Projects, The Data Manager folder is now called Data, so the DataManager class is not in a namespace
named DataManager. Existing projects already have the database value saved so they should not be affected.

Carried over release notes for prior versions:

(Current Release)
DataTier.Net 4.9.5 - Fixed a major bug where the Project References had duplicates. Now there is a constraint on the ProjectReferences table to not allow duplicates by ReferenceName and ProjectId. Also, now you can double click on the Project References in the References Set Editor to open.

(legacy)
DataTier.Net 4.9.3

A vulnerability was found in System.Data.SqlClient, so I update the NuGet package to 4.8.6.

DataTier.Net 4.9.2

This release was created because DataTier.Net now has a new Version 2 template structure with only two projects:

Data Access Component
Object Library

All the functionality is the same for now as the 4 project structure. Two projects makes it simpler to deploy.

The Object Library could be included in the Data Access Component, but I think it is better to separate them.

After installation, follow these steps:

Create a SQL Server Database named DataTier.Net.Database
Run DataTier.Net and follow the instructions on the Setup screen to create your SQL Server database DataTier.Net.Database.

The Setup Control will walk you through setting up DataTier.Net and and creating your connection string and Environment Variable.

Manual Installation (legacy)

The typical location of database scripts:

C:\Program Files (x86)\DataJuggler\DataTier.Net\SQL Scripts\DataTier.Net.Database.Schema.sql

Execute the script DataTier.NET.Database.Schema.sql

Create a User Level Environment Variable named DataTierNetConnection, and set the value to a connection string for your DataTier.Net.Database.

Tip: Connection Builder is installed and will have a shortcut on your desktop. Use Connection Builder to create your connection string.

Example Connection String using Windows Authentication. Replace (Server Name) with your Server Name.

Data Source=(Server Name);Initial Catalog=DataTier.Net.Database;Integrated Security=True;Encrypt=False;

Fixes

Fixed in version 4.9.2: Confirm Changes Control and Confirm Removal Control now handle the new Data Manager folder to Data for V2 projects.

Fixed in version 4.9.1: DataTier.Net Database was updated

Assets 3
Loading