C#

protected void Page_Load(object sender, EventArgs e)
{
    SqlConnection sqlCon = new SqlConnection("server=localhost;database=Database;Trusted_Connection=yes;connection timeout=8");

    try
    {
        sqlCon.Open();
    }
    catch (Exception err)
    {
        errorLbl.Text = err.ToString();
    }
}

MetadataExchangeClient mexClient = new MetadataExchangeClient(new Uri(sWSDL), MetadataExchangeClientMode.HttpGet);
            mexClient.ResolveMetadataReferences = true;
            MetadataSet metaDocs = mexClient.GetMetadata();

            WsdlImporter importer = new WsdlImporter(metaDocs);
            ServiceContractGenerator generator = new ServiceContractGenerator();

            // Add our custom DCAnnotationSurrogate 
            // to write XSD annotations into the comments.
            object dataContractImporter;
            XsdDataContractImporter xsdDCImporter;
            if (!importer.State.TryGetValue(typeof(XsdDataContractImporter), out dataContractImporter))
            {
                Console.WriteLine("Couldn't find the XsdDataContractImporter! Adding custom importer.");
                xsdDCImporter = new XsdDataContractImporter();
                xsdDCImporter.Options = new ImportOptions();
                importer.State.Add(typeof(XsdDataContractImporter), xsdDCImporter);
            }
            else
            {
                xsdDCImporter = (XsdDataContractImporter)dataContractImporter;
                if (xsdDCImporter.Options == null)
                {
                    Console.WriteLine("There were no ImportOptions on the importer.");
                    xsdDCImporter.Options = new ImportOptions();
                }
            }
            
            //xsdDCImporter.Options.DataContractSurrogate = new DCAnnotationSurrogate();????

            // Uncomment the following code if you are going to do your work programmatically rather than add 
            // the WsdlDocumentationImporters through a configuration file. 
            
            // The following code inserts a custom WsdlImporter without removing the other 
            // importers already in the collection.
            System.Collections.Generic.IEnumerable<IWsdlImportExtension> exts = importer.WsdlImportExtensions;
            System.Collections.Generic.List<IWsdlImportExtension> newExts 
              = new System.Collections.Generic.List<IWsdlImportExtension>();
            foreach (IWsdlImportExtension ext in exts)
            {
              Console.WriteLine("Default WSDL import extensions: {0}", ext.GetType().Name);
              newExts.Add(ext);
            }
            //newExts.Add(new WsdlDocumentationImporter());
            System.Collections.Generic.IEnumerable<IPolicyImportExtension> polExts = importer.PolicyImportExtensions;
            importer = new WsdlImporter(metaDocs, polExts, newExts);
            

            System.Collections.ObjectModel.Collection<ContractDescription> contracts
              = importer.ImportAllContracts();
            importer.ImportAllEndpoints();
</pre>
<div class="signature">Marcus Spitzmiller</div>