Microsoft Office Tutorials and References
In Depth Information
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT ServerName, ServerIP, ServerStatus from tblServerStatus
END
the stored procedure code is explained toward the end of this chapter in the section “Understanding
the Custom Data provider Code.”
Note
Writing the WCF Service library and hosting it in IIS
4.
open Microsoft Visual studio 2012, choose to create a new project, and from the available
templates select Visual C# ➤ WCF ➤ WCF service application. then provide a proper
Name and Location. Make sure you pick .Net Framework 4.5. this creates a service class
(service1.svc) and an interface (iservice1.cs).
5.
rename the default Service1.svc file and the interface class to ServerStatus.svc and
IServerStatus.cs , respectively. ensure that all the references under the project reflect this
name change.
6.
after completing these steps, your project should look like the one in Figure 2-75 .
Figure 2-75. Setting up a WCF service application project in Visual Studio 2012
7.
open the Web.config file, and add an entry under the connectionStrings section
(connection string to the Visioservices sQL server database) as follows:
<connectionStrings>
<add name="VisioServicesConnectionString" connectionString="Data Source=ServerName;
Initial Catalog=VisioServices;Integrated Security=SSPI;User Id=userId;Password=pwd"
providerName="System.Data.SqlClient"/>
</connectionStrings>
 
 
Search JabSto ::




Custom Search