DBSync.Net
1.0.3
dotnet add package DBSync.Net --version 1.0.3
NuGet\Install-Package DBSync.Net -Version 1.0.3
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="DBSync.Net" Version="1.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DBSync.Net --version 1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DBSync.Net, 1.0.3"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install DBSync.Net as a Cake Addin
#addin nuget:?package=DBSync.Net&version=1.0.3
// Install DBSync.Net as a Cake Tool
#tool nuget:?package=DBSync.Net&version=1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
DBSync.Net
A c# library used to syncronice model lists with databases
Note:
This library is still under development. If you use it for production you do this on your own risk
Features:
- One or more database server support
- Optional encryption for important data
- Only c# has to be used. No SQL needed
- In-Memory cache
- Threadsafe
Future Features:
- Store json objects
- Encrypt json objects
- Connection string builder
Quick Start
- Create a model
public class TestyModel : IDBSyncModel
{
[Key("id")] // This is not optional
[PrimaryKey]
[AutoIncrement]
public int Id { get; set; }
[Key("text")]
[Length(324)] // Custom max. length
public string Text1 { get; set; } // The property name must not be the key name
[Key("data")]
[Encrypt] // This encrypts the value with the provided key which can be set in the table properties
public string Data { get; set; }
}
- Initialize table
var table = new DBSyncTable<TestyModel>("tablename");
table.ConnectionString = new DBSyncConnectionString()
{
// Set with properties here
};
table.EncryptionKey = "Optional, encryption key";
table.Init(); // This creates the table in the db if its missing and loads data from it to the cache
- Use it
Use can use it basicly like any other IList object.
table.Add(new TestyModel()
{
Text1 = "Hmmmm",
Data = "Secret"
});
table.Clear();
Additional things:
You can configure a global connection string and encryption key which will be used if its not set before
DBSyncGlobal.ConnectionString = "This will be used on every table if its not set for this table specificly";
DBSyncGlobal.EncryptionKey = "Same as above";
Examples can be found in the test project
Licensing:
See LICENSE file
Contact:
If you have any questions feel free to ask me via:
Discord: masusniper#0001
Mail: admin@endelon-hosting.de
Mail: marcel.kbkm@gmail.com
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 is compatible. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp3.1 is compatible. |
.NET Framework | net452 is compatible. net46 is compatible. net461 is compatible. net462 is compatible. net463 was computed. net47 is compatible. net471 is compatible. net472 is compatible. net48 is compatible. net481 was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETCoreApp 3.1
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.5.2
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.6
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.6.1
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.6.2
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.7
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.7.1
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.7.2
- MySql.Data (>= 8.0.28)
-
.NETFramework 4.8
- MySql.Data (>= 8.0.28)
-
net5.0
- MySql.Data (>= 8.0.28)
-
net6.0
- MySql.Data (>= 8.0.28)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.