Web Connection User Discussions
using web connection with sql server in the cloud
Gravatar is a globally recognized avatar based on your email address. using web connection with sql server in the cloud
  Zul
  All
  May 29, 2018 @ 10:40pm

Recently purchased web connection 6.20. I am trying to figure out how to connect to a cloud sql database and use CRUD using MVC and wwBusiness object but cannot find any examples or samples in the documentation.

Also I was looking for some examples of one to many scenarios like an invoice with header and detail tables linked for the same CRUD operation using MVC and wwBusiness objects.

Any help is much appreciated.

Gravatar is a globally recognized avatar based on your email address. re: using web connection with sql server in the cloud
  Rick Strahl
  Zul
  May 29, 2018 @ 11:39pm

Which part?

Using a cloud database like Sql Azure is just a matter of setting the connection string provided by the SQL cloud provider along with giving access to the database. Then use Sql Passthrough, or wwBusiness in SQL Mode. IOW, there's nothing special about a 'cloud database' over a local database.

+++ Rick ---

Gravatar is a globally recognized avatar based on your email address. re: using web connection with sql server in the cloud
  Zul
  Rick Strahl
  May 30, 2018 @ 12:23am

Thanks Rick. I was going through all the documentation and figured that out. Thanks again for the quick response.

© 1996-2024