Is it Possible to Use Microsoft SQL Server Instead of MySQL?

[TechNo.]

Normally I do my SQL work and development using Microsoft SQL Server. I recently got into starting development on my own gamemode and was curious if I can connect it to MS SQL Server or does it have to be MySQL?

Thanks in advance!

Edited January 30, 2022 by TechNo.
Changing title

[GL1TCH1337]

You can use whatever you want. Just install proper libraries. MySQL is not mandatory. 

[Zekiloni]

Yes it is.

[TechNo.]

13 hours ago, GL1TCH1337 said:

You can use whatever you want. Just install proper libraries. MySQL is not mandatory. 

 

11 hours ago, Zekiloni said:

Yes it is.

Thanks for the help! 

[TechNo.]

I attempted to make a connection to my Microsoft SQL Server instance and I'm not having any luck. The RAGE MP Server is blowing up on the System.Data.SqlClient call and saying that it is not supported on this platform. I put the System.Data.SqlClient.dll into the resources -> project -> bin -> debug -> netcoreapp3.1 and it's still not working. It also blows up saying that it's looking for System.Data.SqlClient.resources.dll and when I renamed it to this (or kept one of each in the directory) it still throws the same error for it not being supported on this platform.

Here are my dependencies from Nuget Package Manager:

And here is a snip of my server-files -> dotnet -> resources -> Project -> bin -> Debug -> netcoreapp3.1

Does anyone have any suggestions as to how I can go about fixing this? 

Edited February 5, 2022 by TechNo.

[Xabi]

Which folder did you take that System.Data.SqlClient.dll from? If you remove it from runtime folder, you're asked to include it again?

[TechNo.]

8 hours ago, Xabi said:

Which folder did you take that System.Data.SqlClient.dll from? If you remove it from runtime folder, you're asked to include it again?

I took the System.Data.SqlClient directly from the Path that was in Visual studio. This was:

C:\Users\myUser\.nuget\packages\system.data.sqlclient\4.8.3\ref\netcoreapp2.1\System.Data.SqlClient.dll

This is what the Server Files -> dotnet -> runtime folder looks like and it contains the System.Data.SqlClient.dll.

With it in this runtime path, I receive this error during debugging in Visual Studio which is the same as before: 

And the server console displays this stack trace:

When I remove the SQL dll from this runtime path, I still get the same errors in the two screenshots above.