dotnet add package CrocDB.NET Create a configuration file (e.g., crocdb.config ) to specify database connection settings:
CrocDB.NET supports LINQ, allowing you to query databases using a more expressive and intuitive syntax: crocdb.net
// Create a new customer var customer = new Customer { Name = "John Doe", Email = "johndoe@example.com" }; CrocDB.Context.Customers.Insert(customer); dotnet add package CrocDB
using (var transaction = CrocDB.Context.BeginTransaction()) { try { // Perform database operations CrocDB.Context.Customers.Insert(new Customer { Name = "John Doe", Email = "johndoe@example.com" }); CrocDB.Context.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); // Handle exception } } Email = "johndoe@example.com" }
<?xml version="1.0" encoding="utf-8"?> <crocdb> <database> <provider>SqlServer</provider> <connectionString>Data Source=myServer;Initial Catalog=myDatabase;User ID=myUser;Password=myPassword;</connectionString> </database> </crocdb> Create .NET classes that represent your database tables:
Install-Package CrocDB.NET Alternatively, you can install it via .NET CLI: