What Programming Language to edit Visual Studio built-in Database?

Question

I've just got anassignment from my university to create a program for production scheduling in manufacturing industry. Through this program I need to input, update, delete and show the data from database using somekind of interface.

I could make this program using Visual Studio + Xampp MySQL as Database. However, my university asked me to make the program with built-in Database without installing Xampp or 3rd party database software.

So, my question is does storing data to built-in Database in Visual Studio has the same way as using Xampp MySQL?

In MySQL I could se imports.mysql.data , then .conn, etc but how could I do that in Visual Studio built-in database? is the language the same? if not then what programming language should i use?

Please help, Thanks

Answer 1

Visual studio is made by microsoft, and the database built by them as well is sqlserver
Now visual studio offers various ways to interact with its built-in database without writing sql code. But you need to know at least the sqlserver syntax for it to make sure everything is as you want it to be