TSQL String Split

Examples A. Split comma-separated value string Parse a comma-separated list of values and return all non-empty tokens. STRING_SPLIT will return empty string if there is nothing between separator. Condition RTRIM(value) <> ” will remove empty tokens. B. Split comma-separated value string in a column Product table has a column with comma-separate list of tags shown... » read more

Gmail, Add Additional Email Alias

Gmail Admin https://admin.google.com Add an email alias for a G Suite user You can add up to 30 aliases for each user. Sign in to your Google Admin console. From the Admin console Home page, go to Users. In the Users list, find the user. If you need help, see Find a user account. Click the user’s name to open their account page. Click User information  Email... » read more

Consuming a WCF Host

WCF Endpoint http://localhost:57945/Service1.svc Use the following to generate a service reference in your Connected Services client application… http://localhost:57945/Service1.svc?singleWsdl After you have generated the service reference objects, you can call the service directly from within your client application. If you have more that one end points, you will need to specify which end point to use.

Simple WCF Application

When you create a WCF application in Visual Studio. The project creates 2 classes for you. It also link it to the WCF Test Client. Interface and Data Contract class (.cs) Both Interface and Data Contact. The Data Contact can be its own separate class. Service Class (.svc) Implements IService1 Interface. WCF Test Client

Web Service vs WCF Service

WCF is a service layer that allows you to build applications that can communicate using a variety of communication mechanisms. With it, you can communicate using Peer to Peer, Named Pipes, Web Services and so on. You can’t compare them because WCF is a framework for building interoperable applications. If you like, you can think... » read more

Service Oriented Architecture‎ (SOA)

Service-oriented architecture (SOA) is a style of software design where services are provided to the other components by application components, through a communication protocol over a network. The basic principles of service-oriented architecture are independent of vendors, products and technologies. A service is a discrete unit of functionality that can be accessed remotely and acted upon... » read more

C# Data Contracts

A data contract is a formal agreement between a service and a client that abstractly describes the data to be exchanged. That is, to communicate, the client and the service do not have to share the same types, only the same data contracts. A data contract precisely defines, for each parameter or return type, what data... » read more