Adr.MyORMForMySQL
3.0.0
dotnet add package Adr.MyORMForMySQL --version 3.0.0
NuGet\Install-Package Adr.MyORMForMySQL -Version 3.0.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="Adr.MyORMForMySQL" Version="3.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Adr.MyORMForMySQL --version 3.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Adr.MyORMForMySQL, 3.0.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 Adr.MyORMForMySQL as a Cake Addin
#addin nuget:?package=Adr.MyORMForMySQL&version=3.0.0
// Install Adr.MyORMForMySQL as a Cake Tool
#tool nuget:?package=Adr.MyORMForMySQL&version=3.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
MyORMForMySQL
MyORMForMySQL is a implementation of MyORM that uses MySQL as database.
Installation
.NET CLI
dotnet add package Adr.MyORMForMySQL --version 3.0.0
Nuget package manager
PM> Install-Package Adr.MyORMForMySQL -Version 3.0.0
packageReference
<PackageReference Include="Adr.MyORMForMySQL" Version="3.0.0" />
Usage
Create a instance of MySQLContext:
public class Context : MySQLContext
{
public Context(MySQLConnectionBuilder builder) : base(new MySQLManager(builder)) { }
public MySQLCollection<Item> Items { get; set; }
public MySQLCollection<Order> Orders { get; set; }
}
Using a instance of MySQLContext:
public class OrderService
{
Data.Context _context;
public OrderService(Data.Context context)
{
_context = context;
}
public async Task Add(Order order)
{
await _context.Orders.AddAsync(order);
}
public async Task<IEnumerable<Order>> GetAll()
{
return await _context.Orders.OrderBy(d => d.Id).Join(d => d.Item).ToListAsync();
}
public async Task<Order?> Find(long id)
{
return await _context.Orders.Where(d => d.Id == id).FirstAsync();
}
public async Task<IEnumerable<Order>> GetFirst10()
{
return await _context.Orders.Take(10);
}
}
Sample of DI and IS, so we can change database easily:
public class OrderService
{
MyORM.Interfaces.IDBContext _context;
public OrderService(MyORM.Interfaces.IDBContext context)
{
_context = context;
}
public async Task<IEnumerable<Order>> GetAll()
{
return await _context.Collection<Order>().OrderBy(d => d.Id).Join(d => d.Item).ToListAsync();
}
}
For web
MyORMForMySQL.Objects.MySQLConnectionBuilder myConnBuilder =
new MyORMForMySQL.Objects.MySQLConnectionBuilder
(user: "<user>", password: "<pass>", port: <port>, dataBase: "<database>");
builder.Services.AddScoped<MyORM.Interfaces.IDBContext, erp.Data.Context>(
options => {
return new Data.Context(myConnBuilder);
});
new Data.Context(myConnBuilder).UpdateDataBase();
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
License
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
- Adr.MyORM (>= 3.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
3.0