v5.0.2

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

DataTier.NET 5.0.1

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

DataTier.NET Version 5.0.0 is here!

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.

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

v.4.9.5

(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

v4.9.4

DataTier.Net 4.9.4 - A bug was found in the Controller Editor was not allowing you to edit References Sets. Fixed.

DataTier.Net 4.9.3

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

(legacy)

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

DataTier.Net 4.9.3

(Current Release)
DataTier.Net 4.9.3

A vulnerability was found in System.Data.SqlClient version 4.8.5 or below. I updated to 4.8.6 to address this.
I do not build new .NET Framework projects any more, so I will not be updating the older project templates.

Project templates targeting .NET 5 - .NET 8 use Microsoft.Data.SqlClient, so they are not affected by this vulnerability.

(legacy)
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

DataTier.Net 4.9.2

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

DataTier.Net4.9.1

DataTier.Net 4.9.1

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:

1. Create a SQL Server Database named DataTier.Net.Database
2. Execute the SQL Script DataTier.Net.Database.Schema.sql, which can be found in your install directory.

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

3. 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;

DataTier.Net 4.9.0

DataTier.Net 4.9.0

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:

1. Create a SQL Server Database named DataTier.Net.Database
2. Execute the SQL Script DataTier.Net.Database.Schema.sql, which can be found in your install directory.

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

3. 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;

No file chosen
Attach files by dragging & dropping, selecting or pasting them.
DataTier.Net4.8.1.msi
(29.4 MB)
No file chosen
Attach binaries by dropping them here or selecting them.
Set as a pre-release
This release will be labeled as non-production ready
Set as the latest release
This release is labeled as the latest for this repository.
Tagging suggestions
It’s common practice to prefix your version names with the letter v. Some good tag names might be v1.0.0 or v2.3.4.

If the tag isn’t meant for production use, add a pre-release version after the version name. Some good pre-release versions might be v0.2.0-alpha or v5.9-beta.3.

Semantic versioning
If you’re new to releasing software, we highly recommend to learn more about semantic versioning.

A newly published release will automatically be labeled as the latest release for this repository.

If 'Set as the latest release' is unchecked, the latest release will be determined by higher semantic version and creation date. Learn more about release settings.

Footer
© 2024 GitHub, Inc.
Footer navigation
Terms
Privacy
Security
Status
Docs
Contact
Manage cookies
Do not share my personal information
Edit release · DataJuggler/DataTier.Net

DataTier.Net 4.8.1

This release was created because DataTier.Net now supports targeting .NET 8.

After installation, follow these steps:

1. Create a SQL Server Database named DataTier.Net.Database
2. Execute the SQL Script DataTier.Net.Database.Schema.sql, which can be found in your install directory.

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

3. 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;