using
Microsoft.SharePoint.Client;
System;
System.Collections.Generic;
System.Data.EntityClient;
System.Linq;
System.Web;
System.Web.Configuration;
namespace
MovemberWeb.Util
{
public
class
ConnectionUtil
static
string
GetEntityConnectionString(ClientContext clientContext)
//try to get the connection string from from the clientContext
clientContext.Load(clientContext.Web, web => web.Title);
ClientResult<
> result = AppInstance.RetrieveAppDatabaseConnectionString(clientContext);
clientContext.ExecuteQuery();
connString = result.Value;
//if the connection string is empty, then this is debug mode
if
(String.IsNullOrEmpty(connString))
connString = WebConfigurationManager.ConnectionStrings[
"LocalDBInstanceForDebugging"
].ConnectionString;
//build an Entity Framework connection string
EntityConnectionStringBuilder connBuilder =
new
EntityConnectionStringBuilder();
connBuilder.Provider =
"System.Data.SqlClient"
;
connBuilder.ProviderConnectionString = connString;
connBuilder.Metadata =
"res://*/MovemberModel.csdl|res://*/MovemberModel.ssdl|res://*/MovemberModel.msl"
//return the formatted connection string
return
connBuilder.ConnectionString;
}
Maheshkumar S Tiwari edited Revision 4. Comment: Added tags
Margriet Bruggeman edited Revision 1. Comment: add
Margriet Bruggeman edited Original. Comment: add