Using NuGet Cassandra database package in C#

FiveM Resource Development & Modding Discussion
1

Hi, I’m very new in C# programming and I want to ask is it possible to get Cassandra database package for C# .NET and use it as a primary database in scripting. I’m curious, because in FiveM people mostly uses MySQL, so I’m thinking is that a limitation or just a popular opinion?
I can use whatever I want from internet of libraries for C#?

2

As long as the package supports .NET Framework 4.5.2 and you don’t use TLS/SSL for your database connection, it should work (the mono version that FiveM uses doesn’t have SSL)

3

Thank you for pointing that out :slight_smile:
I won’t use TLS/SSL, database will be local, private.

4

Okay I’ve tried this:

Cluster cluster = Cluster.Builder().AddContactPoint("127.0.0.1").Build();
// ISession freezes server!
ISession session = cluster.Connect("gta");

This line freezes server when is executed. What can I do?
Server prints message:

Loaded Cassandra, Version=3.99.0.0, Culture=neutral, PublicKeyToken=10b231fbfc8c4b4d into ScriptDomain_1005648851
[SERVER]Hello World! My Tick!!!!!!!!!!!!!!!!!!!!!!!Loaded Microsoft.Extensions.Logging.Abstractions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60 into ScriptDomain_1005648851
Loaded Microsoft.Extensions.Logging, Version=1.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60 into ScriptDomain_1005648851
5

Okay, so I managed that.
I can’t use Sync functions when there is timeout connection, so it will freeze server, logically.
Using Async helps to figure out that it is exactly TIMEOUT.