...To install EF Core, you install the package for the EF Core database provider(s) you want to target. This tutorial uses SQLite because it runs on all platforms that .NET Core supports. This application intentionally keeps things simple for clarity. Connection strings should not be stored in the code for production applications. You may also want to split each C# class into its own file.
SmartSql is a lightweight, high-performance ORM for .NET inspired by MyBatis. It provides a hybrid approach that separates SQL from application code while supporting dynamic queries, mapping, and caching. With XML or annotation-based configuration, SmartSql is designed to balance control and productivity for .NET developers.
...It is a simple yet powerful object mapping tool for any .NET language, such as C#, that enables developers to quickly and easily map query results from ADO.NET data readers to instances of business objects. It has excellent support for both asynchronous and synchronous database queries and batching multiple queries together into a single call.
A Mapping generator for NHibernate (NH) via FluentNH and NH.Burrows. Generate source code in C# to access MySql or SQL Server dbs. VB.Net may be supported eventually. See Develop > News menu for updates and release notes.
Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.
Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.