I am going to develop a window based application using c# 4.0. It is a database driven application, i.e it is going to have some manipulating the records of students and other stuffs.
I use to work basically on web platform, but on this project, I have to use c# window forms.
So those were my scenario, now come back to my question. I am confuse to selecting the right database. I am very comfortable with SQL Server. but can i use that in my window based application? I mean, after completing my project, I have to deploy the software, and make an exe file, which would be running on any computer. What i dont want is that, the user who would be using the software, should not be aware of the running database. If i use SQL server with my window app, so at the time of installation to user computer, will I need to install the SQL server on that system too? Or I can include some basic dlls in my project at the time of deployment? so the user just need to install that exe or setup file of my project, and every thing functional..
I think I was able to express my questions.
Please, need some urgent advise on it.
Thanx
Ravi ShekharPosted Jul 18, 2013, 4:21 AM
if you are making a small apps or then you can use sql server express edition(Free).
In my point of view if you dont have any DBA . and you are using sql server at the specific stage when your data is reached 1 crore or above . at that time you face many problem with sql server. very typical to manage for developers.
with huge amount of data your apps works very slow with sql server.
Choose database as per your requirement.
mark it as answer if it helped
Iftikar HussainPosted Jul 18, 2013, 4:09 AM
Regards,
Iftikar
Imteyaz ahmadPosted Jul 18, 2013, 3:44 AM
Iftikar HussainPosted Jul 18, 2013, 3:30 AM
Please refer this link
http://www.c-sharpcorner.com/Ebooks/Free/54/
Regards,
Iftikar