CPSysUDB 3.1.0

dotnet add package CPSysUDB --version 3.1.0
NuGet\Install-Package CPSysUDB -Version 3.1.0
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="CPSysUDB" Version="3.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CPSysUDB --version 3.1.0
#r "nuget: CPSysUDB, 3.1.0"
#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 CPSysUDB as a Cake Addin
#addin nuget:?package=CPSysUDB&version=3.1.0

// Install CPSysUDB as a Cake Tool
#tool nuget:?package=CPSysUDB&version=3.1.0

[pt-BR]
     .NET Framework 4.7.2 ou posterior
     * Uso de entidades (classes), cada entidade é uma tabela no banco de dados
     * Rotina para sempre recriar o banco de dados (muito útil para desenvolvimento) com opção para desabilitar
     * Controle total das rotinas de criação e atualização do banco de dados
     * Comunicação híbrida com SQL Server, MySQL, Firebird e SQLite sem necessidade de criar querys separadas apenas trocando os dados de conexão
     * Auto atualização do banco de dados, tabelas e campos
     * Criação de PK com auto incremento e FK
     * Respeitar regras do banco de dados (não usar palavras reservadas, criação das tabelas por dependência, ...)
     * Cria o banco de dados automaticamente
     * Create DataBase, Create Table, Insert, Update, Delete, Select
     * Uso de funções como count, max, min, avg, upper, lower, trim nos campos do select e do where
     * Where, Order By, Group By, Union, Limit e Joins
     * Suporte para int, string, DateTime, double e enum
     * Suporte para funções do banco de dados como GETDATE e DATEADD
     * Suporte para usar um campo de uma tabela no where
     * Compatível com WEB e Desktop
     [en-US]
     .NET Framework 4.7.2 or later
     * Usage of entities (class), each entity is a table in the database
     * Routine to always recreate the database (very useful for development) with option to disable
     * Full control of database creation and update routines
     * Hybrid communication with SQL Server, MySQL, Firebird and SQLite without the need to create separate queries just exchanging connection data
     * Auto update of database, tables and fields
     * PK creation with auto increment and FK
     * Respect database rules (do not use reserved words, creation of tables by dependency, ...)
     * Creates the database automatically
     * Create DataBase, Create Table, Insert, Update, Delete, Select
     * Use of functions like count, max, min, avg, upper, lower, trim in select and where fields
     * Where, Order By, Group By, Union, Limit and Joins
     * Support for int, string, DateTime, double and enum
     * Support for database functions like GETDATE and DATEDD
     * Support for using a field from a table in where
     * Compatible with WEB and Desktop

Product Compatible and additional computed target framework versions.
.NET Framework net472 is compatible.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.1.0 308 1/19/2024
3.0.0 636 9/30/2023
2.5.1 623 9/13/2023
1.0.3.11 975 8/10/2021

[pt-BR]
     - Adicionado forma de ler os dados da conexão;
     [en-US]
     - Added way to read connection data;