SessionHeader crmSessionHeader = new SessionHeader();

WebServiceSoapPort CRMService = new WebServiceSoapPortClient();

void GetAllRecordsInEntity()

        {

            string listofFields = "";// blank will return all the fields or you can set the comma separated column names;

            string whereClause = "";//" blank for no condition or set as "type='user'" for condition

            string entityName = "Users";// Define entity name (which is a database table) here 

            string orderBy = "";// set  order by with desired column

            queryrecordResponse objQueryRecordResponse = new queryrecordResponse();

            queryrecordRequest objQueryRecordRequest = new queryrecordRequest();

            objQueryRecordRequest.fieldlist = listofFields;

            objQueryRecordRequest.entityname = entityName;

            objQueryRecordRequest.queryString = whereClause;

            objQueryRecordRequest.orderby = orderBy;

            objQueryRecordRequest.SessionHeader = crmSessionHeader;            

            objQueryRecordResponse = CRMService.queryrecord(objQueryRecordRequest);

            queryrecordresult myQueryRecordResult = objQueryRecordResponse.result;            

            crmrecord[] myRecordList = myQueryRecordResult.records;            

            for (int i= 0; i< myRecordList.Length; i++)

            {

                recordfield[] myFieldList = myRecordList[i].records;

                for (int j= 0; j< myFieldList.Length; j++)

                {

                    recordfield myField = (recordfield)myFieldList[j];

                   //use myField.name for column name and  myField.value for value field

                }

            }

        }

<system.serviceModel>

        <bindings>

            <basicHttpBinding>

                <binding name="WebServiceSoapBinding" closeTimeout="00:01:00"

                    openTimeout="00:01:00" receiveTimeout="00:10:00" sendTimeout="00:01:00"

                    allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"

                    maxBufferSize="65536" maxBufferPoolSize="524288" maxReceivedMessageSize="65536"

                    messageEncoding="Text" textEncoding="utf-8" transferMode="Buffered"

                    useDefaultWebProxy="true">

                    <readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384"

                        maxBytesPerRead="4096" maxNameTableCharCount="16384" />

                    <security mode="None">

                        <transport clientCredentialType="None" proxyCredentialType="None"

                            realm="" />

                        <message clientCredentialType="UserName" algorithmSuite="Default" />

                    </security>

                </binding>

            </basicHttpBinding>

        </bindings> 

WebServiceSoapPort SageCRMService = new WebServiceSoapPortClient();
logonRequest objLogonRequest = new logonRequest();

//Set your CRM Username and Password
objLogonRequest .username = "CRMAdminUser";
objLogonRequest .password = "yourCrmPassword";
logonResponse objLogonResponse = SageCRMService .logon(objLogonRequest );

SessionHeader objSessionHeader = new SessionHeader();
objSessionHeader.sessionId = objLogonResponse .result.sessionid;

logoffRequest objLogoffRequest = new logoffRequest();

objLogoffRequest .SessionHeader = objSessionHeader;
objLogoffRequest .sessionId=objLogonResponse .result.sessionid;
logoffResponse objLogoff = SageCRMService.logoff(objLogoffRequest);