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

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();
  }

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!!!

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!!!