How can i create C# Application Or Project Setup within database?

Question

how can i create a setup of C# application with its SQL Server Database within its file means only one exe file which contain database with in it...means everything (database and source code) is in one file...
if you know how to do it then please help me......
i need to know this thing for my college project....which is in C# with SQL Server 2005 and 2008 (Support both versions of SQL servers)....

Shivanand Arur · Answer

Hey Kaushal when you are developing any application you can directly connect to the Database using Visual Studio's Server Explorer... You can create a connection with your database and can interact with it by adding new tables procedures and many other things... So if you try to deploy your application you have your database connectivity stable in your application... You do not have to create any other database connectivity or any other thing... Plus the changes that you make in your Database using your Sequel Management Studio the changes are again reflected back in your project.... So if you create a new Procedure or a Function using your Sql Management Studio it is shown in your Project's Server Explorer. I hope this what you wanted to know... Thanks!!!

Sudhakar Chaudhary · Answer

you can make a custominstaller which takes the back file .bak of your database and it will be install on client machine. here a sample... public void RestoreDatabase(String databaseName String filePath String serverName String userName String password String dataFilePath String logFilePath) { Restore sqlRestore = new Restore(); BackupDeviceItem deviceItem = new BackupDeviceItem(filePath DeviceType.File); sqlRestore.Devices.Add(deviceItem); sqlRestore.Database = databaseName; ServerConnection connection; // for Windows Authentication if (userName == ) { SqlConnection sqlCon = new SqlConnection(@Data Source= + serverName + @; Integrated Security=True;); connection = new ServerConnection(sqlCon); } // for Server Authentication else connection = new ServerConnection(serverName userName password); Server sqlServer = new Server(connection); Database db = sqlServer.Databases[databaseName]; sqlRestore.Action = RestoreActionType.Database; String dataFileLocation = dataFilePath + databaseName + .mdf; String logFileLocation = logFilePath + databaseName + _Log.ldf; db = sqlServer.Databases[databaseName]; RelocateFile rf = new RelocateFile(databaseName dataFileLocation); sqlRestore.RelocateFiles.Add(new RelocateFile(databaseName dataFileLocation)); sqlRestore.RelocateFiles.Add(new RelocateFile(databaseName + _log logFileLocation)); sqlRestore.ReplaceDatabase = true; sqlRestore.Complete += new ServerMessageEventHandler(sqlRestore_Complete); sqlRestore.PercentCompleteNotification = 10; sqlRestore.PercentComplete += new PercentCompleteEventHandler(sqlRestore_PercentComplete); try { sqlRestore.SqlRestore(sqlServer); } catch (Exception ex) { MessageBox.Show(ex.InnerException.ToString()); } db = sqlServer.Databases[databaseName]; db.SetOnline(); sqlServer.Refresh(); }

Shivanand Arur · Answer

Then u should try to develop a web application... So once you host your application... Your members will be able to use it without any other s/w requirement.... Just can do it through their browser... This is just an advice!!! Thank you!!!

Kaushal Suthar · Answer

Yesbuddy i know that but some times thing happened was that when i deploy my application and then trying to install it in another computer which has not a SQL Server then it's shown a error or kind a message that told me to install a Microsoft SQL Server so All i want to know that how can i deploy a application which must have to ability to run a database operation without installing a M. SQL Server means my application have to carry a built in compact addition of SQL server... Thanks for your time and valuable response..:)