Attaching database

[hadad]

hello, My application depends on a sql server database I want to deploy my project in the client machine with out deploying the sql server express edition because it take some disk space and it some times cause some problems in its deployment(mainly if user don't have any experience).Is there any way to overcome this situation. thanks

Dad

[franz pilgerstorfer]

Hi Right-click your project and add a new installer class. Within your installer class add following code

Public Overrides Sub Install(ByVal stateSaver As \_
  System.Collections.IDictionary)

    MyBase.Install(stateSaver)

    Try
        ' Creates the database.
        ExecuteSql("master", "CREATE DATABASE dbTest")

        ' Creates the tables.
        ExecuteSql(strDBName, "CREATE TABLE .....")

    Catch ex As Exception
        ' Reports any errors and abort.
    End Try   

    
End Sub

I found this code in the net. Although it is written in vb.net it may help you. Franz

[hadad]

thanks for help, but does it will work on a client without installing any version of sql server.The main problem is that the user will use the database as a flat database like the access database. is there a sql engine in framework 2 to attache the database to it. thanks.

Dad

[mark_w_]

So basically what you are saying is you want a database on the client machine, but not install a full database environment, well sql compact is your friend http://www.microsoft.com/sql/editions/compact/default.mspx[^] one thing you cant do is have stored procs tho, but on the plus side its free :)