SqlSrcGen 0.1.3
dotnet add package SqlSrcGen --version 0.1.3
NuGet\Install-Package SqlSrcGen -Version 0.1.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="SqlSrcGen" Version="0.1.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SqlSrcGen --version 0.1.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SqlSrcGen, 0.1.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 SqlSrcGen as a Cake Addin #addin nuget:?package=SqlSrcGen&version=0.1.3 // Install SqlSrcGen as a Cake Tool #tool nuget:?package=SqlSrcGen&version=0.1.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
SqlSrcGen
SqlSrcGen is a SQL first, reflection free micro ORM for SQLite using c# source generators. The class definitions and Object Relational Mappings are created automatically from your SQL CREATE TABLE commands.
Advantages
- No need to manually define c# classes for your tables
- High performance - mapping code is reflection free and optimized at compile time
- SQL code is compile time checked
- AOT friendly - no reflection
Getting Started
- Create a .sql file in your project which includes the CREATE TABLE SQL commands defining your database.
CREATE TABLE contact (name Text not null primary key, email Text not null);
- Include that .sql file as AdditionalFiles in your .csproj
<ItemGroup>
<AdditionalFiles Include="SqlSchema.sql" />
</ItemGroup>
- Do crud operations on the tables
var database = new Database(databaseName);
// create the table
database.CreateContactTable();
// insert a record
database.InsertContact(new Contact()
{
Name = "Steve Rogers",
Email = "steve@avengers.com"
});
// query all records in the table
var list = new List<Contact>();
database.AllContacts(list);
// get row via primary key, (only generated for tables with a primary key)
var contact = new Contact();
bool found = database.GetContact(contact, "Steve Rogers");
// delete all rows from table
database.DeleteAllContacts();
// delete a row via primary key (only generated for tables with a primary key)
database.DeleteContact("Steve Rogers");
// Begin a transaction
database.BeginTransaction();
// Commit a transaction
database.CommitTransaction();
// Rollback a transaction
database.RollbackTransaction();
Future Work
SqlSrcGen currently only supports basic crud operations generated directly from sql table definitions. Future features include:
- Custom queries (select, joins etc)
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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 | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.