<?xml version="1.0"?>
<configuration>
	<system.web>
		<compilation debug="true" targetFramework="4.0"/>
	</system.web>
	<system.serviceModel>
    <behaviors>
			<serviceBehaviors>
				<behavior>
					<!-- Чтобы избежать раскрытия информации метаданных, установите следующее 
          значение в false и удалите конечную точку метаданных перед развертыванием -->
					<serviceMetadata httpGetEnabled="true"/>
					<!-- Для получения деталей исключения при сбоях в целях отладки
          установите следующее значение в true.
          Перед развертыванием установите его снова в false,
          чтобы скрыть информацию об исключении -->
					<serviceDebug includeExceptionDetailInFaults="true"/>
				</behavior>
			</serviceBehaviors>
		</behaviors>
		<serviceHostingEnvironment multipleSiteBindingsEnabled="true"/>
	</system.serviceModel>
	<system.webServer>
		<modules runAllManagedModulesForAllRequests="true"/>
	</system.webServer>
	<connectionStrings>
		<add name="ASU_DATA" connectionString="Data Source=MS2008B;Initial Catalog=ASU_MKVI_DATA_tester2;Password=Qwerty1;User ID=sa"/>
	</connectionStrings>
</configuration>

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <system.serviceModel>
        <bindings>
            <basicHttpBinding>
                <binding name="BasicHttpBinding_IMKVIService" 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>
        <client>
            <endpoint address="http://localhost/WCFServiceMyProba00/Service.svc"
                binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IMKVIService"
                contract="ServiceReference.IMKVIService" name="BasicHttpBinding_IMKVIService" />
        </client>
    </system.serviceModel>
</configuration>

<security mode="None">
   <transport clientCredentialType="None" proxyCredentialType="None" realm="" />
   <message clientCredentialType="UserName" algorithmSuite="Default" />
</security>

<security mode="TransportCredentialOnly">
  <transport clientCredentialType="Windows" proxyCredentialType="None" realm="" />
  <message clientCredentialType="UserName" algorithmSuite="Default" />
</security>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Xml;
using System.Xml.Linq;

[ServiceContract]
public interface IMKVIService
{
  [OperationContract]
  XDocument GetUtvPlanNIOKR();
}

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Xml;
using System.Xml.Linq;
using NS_ASU_MKVI;

public class MKVIService : IMKVIService
{
  public XDocument GetUtvPlanNIOKR()
  {
    XDocument doc = new XDocument();
    XElement root = new XElement("ROOT");
    XElement record = null;
    XElement node = null;

    // Сначала получим DataTable из базы данных.
    string sql = "SELECT [N_ID] as [N_ID]," +
                        "YEAR([D_DATE]) as [GD]," +
                        "[S_NAME] as [S_NAME]," +
                        "[F_COST] as [F_COST]," +
                        "CONVERT(varchar(10),[D_DATE_BEG],104) as [S_DATE_BEG]," +
                        "CONVERT(varchar(10),[D_DATE_END],104) as [S_DATE_END] " +
                  "FROM [T_NIOKR] " +
                  "WHERE [N_ID_STATE] = 605 " +
                    "and [N_ID_SOST] = 407 " +
                    "and [B_CLOSED] = 0 " +
                    "and [B_OLD] = 0 " +
                  "ORDER BY [N_ID]";
    DataTable dt = DatabaseManager.GetTableByQwery(sql);
    DataTableReader reader = dt.CreateDataReader();
    while (reader.Read())
    {
      record = new XElement("GK");
      node = new XElement("ID", reader["N_ID"].ToString());
      record.Add(node);
      node = new XElement("YEAR", reader["GD"].ToString());
      record.Add(node);
      node = new XElement("NAME", reader["S_NAME"].ToString());
      record.Add(node);
      node = new XElement("COST", reader["F_COST"].ToString());
      record.Add(node);
      node = new XElement("SEDATE", reader["S_DATE_BEG"].ToString());
      record.Add(node);
      node = new XElement("EEDATE", reader["S_DATE_END"].ToString());
      record.Add(node);
      root.Add(record);
    }
    doc.Add(root);
    return doc;
  }
}