How to create a database for a chatbot in C# using Visual Studio?

Question

C++ / C#

Hello. How to create a database for a chatbot in C# using Visual Studio? Please provide some documentation on this topic.

Answer 1

For example like this:

public class MyDB
{
    public List<Message> Messages = new List<Message>();
    public List<User> Users = new List<User>();
}

public class Message
{
    public DateTime Time = new DateTime();
    public string Text;
    public ulong UserID;
    public Message(ulong userId, string text)
    {
        Text = text;
        UserID = userId;
    }
}

public class User
{
    private static ulong Cnt = 0;
    public ulong Id;
    public string Name;
    public User(string name)
    {
        Name = name;
        Id = ++Cnt;
    }
}

Answer 2

EntityFramework (Core) + In memory db provider.
If necessary, it will be possible to easily transfer to a "live" base