Is it possible to connect to Microsoft SQL Server database

Development Programming & Scripting Multiplayer & Networking
, ,
1

I have a Visual Studio application, currently in vb.net, but could be moved to C#, which uses Microsoft SQL Server SQL Client very heavily.

I am looking to change the UI of my app from a Winform, datagrid-driven experience to a game engine, but still need capability to display small datatables in the UI. Is this possible?

2

I built a plugin for UE4 that lets me access a MSSQL database from Blueprints in UE4, so it is possible, but you will have to write additional C++ code to get it to work. You cannot use any of the higher level C# SQL libraries like Linq or EF. I used ODBC from C++ and it works great!

3

Thanks Dartanlla, I wonder if you could post your C++ code or a mini-project that would show how you did this?

4

http://blogs.winterleafentertainment.com/post/unreal-engine-odbc-support-through-c

5

Just wanted to mention this here:

SQLite only supports a single writer at a time (meaning the execution of an individual transaction). SQLite locks the entire database when it needs a lock (either read or write) and only one writer can hold a write lock at a time. Due to its speed this actually isn’t a problem for low to moderate size applications, but if you have a higher volume of writes (hundreds per second) then it could become a bottleneck.

nanoobdc is a sqlite wrapper

6

Just wanted to mention this here:

SQLite only supports a single writer at a time (meaning the execution of an individual transaction). SQLite locks the entire database when it needs a lock (either read or write) and only one writer can hold a write lock at a time. Due to its speed this actually isn’t a problem for low to moderate size applications, but if you have a higher volume of writes (hundreds per second) then it could become a bottleneck.

7

That resource is not SQLLite, it is a full blown ODBC C++ connection library. It provides the linkage you need to make a connection to a SQL Server, MySQL Server, or any other ODBC compliant database.

8

You can use any C# libraries you want in C++. I just did the same through dll import , since I am not from C++ background , I found it convenient to create database operations through C# and use C++ to call the C# function.