EugeneChiang.com

Just My Code Debugging

Sources: https://docs.microsoft.com/en-us/visualstudio/debugger/just-my-code?view=vs-2019

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

TSQL Convert

DATETIME to DATE and TIME Should I use CAST or Convert? Unless you have some specific formatting requirements you’re trying to address during the conversion, I would stick with using the CAST function.  There are several reason I can think of: CAST is ANSI-SQL compliant; therefore, more apt to be used in other database implementation.... » read more

TSQL CAST

INT to VARCHAR DATETIME to DATE and TIME Should I use CAST or Convert? Unless you have some specific formatting requirements you’re trying to address during the conversion, I would stick with using the CAST function.  There are several reason I can think of: CAST is ANSI-SQL compliant; therefore, more apt to be used in... » read more

TSQL Check if record exist

TSQL Cursor