Deploy user define function for SQL server

1. right-click on project and then click properties

2. on tab database click "browse..." to select Host and database to deploy

3. if have database go to step 7 else just click Add New Reference

4. input Server name: (1), then select "Use SQL Server Authentication" input User name: and password: (2), then click "Test Connection" (3)

5. result can connect database

6. select database to deploy (1) and click "OK" (2)

7. if have data to deploy select data base connection and click "OK"

8. build project by right-click on project then click Build

9. deploy project by right-click on project then click Build