SQL Server Database Project + Windows Form Project - In a Single Solution of Visual Studio RRS feed

  • Question

  • Dear Colleagues,

    Being required for the first time as I seek to develop a User Interface on the Windows Form for a SQL Server Database I shall oblige you experts' advice as to whether should I have both the projects be included in a single solution on VS 2019 or should I place both the projects in separate solutions?

    While I have the complete DB already designed via SQL Server Database Project as I tried to add a Windows Forms App project I don't seem to find the correct way to debug the Form's project with the F5 despite of a valid Data Connection since the solution upon launch is found to be recreating the said database and throwing an error like the tables already existing.

    Thus, if multiple projects like this do exist in a single solution, how to debug a single project of the same?

    Any helpful advice / reference of a good source of info in this regard shall be highly obliged.

    Thanks in advance,

    Best Regards

    Sunday, June 16, 2019 3:38 PM


All replies

  • I am not sure I understand but if you are not familiar with the use of a project's properties to not copy the database then look at the properties for the relevant project and set the property for the database to not copy the database when the project is built. I am not sure where that is, it is probably in the build properties.

    Sam Hobbs

    Sunday, June 16, 2019 8:42 PM
  • When you have several Projects within a solutuin, then you can define which one (or more) should start during Debugging; see How to: Set multiple startup projects

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, June 17, 2019 6:50 AM