Getting started with SingleStore and C# Entity Framework ORM

Attention: The code in this repository is intended for experimental use only and is not fully tested, documented, or supported by SingleStore. Visit the SingleStore Forums to ask questions about this repository.

Whether you're using an ORM like Entity Framework or straight SQL, you can get started with SingleStore (formerly MemSQL) fast. Here's an introductory sample of using SingleStore with C#. This sample includes Entity Framework running all the CRUD methods: Create, Read by id, Read all, Update, and Delete.

Usage

1. Sign up for a free SingleStore license. This allows you to run up to 4 nodes up to 32 gigs each for free.

2. Spin up a SingleStore cluster. Choose the deployment strategy that makes sense to you:

   a. Cloud: Start a Managed Service trial and run init.sql.

   b. VMs: Install SingleStore on a supported Linux distribution then run init.sql.

   c. Containers: Grab your license key from SingleStore portal and set it into docker-compose.yaml. Then run docker-compose up to start the cluster and automatically run init.sql.

3. Adjust the connection details in appsettings.Development.json, run dotnet restore, and then run the app.

License

MIT