Saturday, February 28, 2015

Enterprise WSDL .Net Unable to generate a temporary class (result=1)

"Unable to generate a temporary class (result=1)" is returned when .Net integration tries to parse the Enterprise WSDL version 32.0, 33.0         


Unable to generate a temporary class (result=1).
error CS0030: Cannot convert type 'sfweb.ListViewRecordColumn[]' to 'PBusinessLayer.sfweb.ListViewRecordColumn'
error CS0030: Cannot convert type 'sfweb.ListViewRecordColumn[]' to 'PBusinessLayer.sfweb.ListViewRecordColumn'
error CS0029: Cannot implicitly convert type 'sfweb.ListViewRecordColumn' to 'PBusinessLayer.sfweb.ListViewRecordColumn[]'
error CS0029: Cannot implicitly convert type 'sfweb.ListViewRecordColumn' to 'sfweb.ListViewRecordColumn[]'


  • Find "ListViewRecord"
  • Change Only "<xsd:attribute name="tmp" type="xsd:string" />"

<complexType name="ListViewRecord">
                <sequence>
                    <element name="columns"                  type="tns:ListViewRecordColumn" maxOccurs="unbounded"/>
                </sequence>
<xsd:attribute name="tmp" type="xsd:string" />
            </complexType>

Saturday, February 21, 2015

SQL Server Alter Table add Multiple Column

To insert columns into a table

  1. Connect to the Database Engine.
  2. From the Standard bar, click New Query.
  3. The following example adds two columns to the table dbo.doc_exa. Copy and paste the following example into the query window and click Execute
Alter Table dbo.Lead
add  Title varchar(50) null,
  Phone varchar(50) null,
  LeadSource varchar(50) null,
  LeadSourceDetails varchar(50),
  CustomerSubtypeOther varchar(50),
  InterestDetails varchar(50),
  CustomerSubtype varchar(50),
  Interest varchar(50),
  Street varchar(50),
  City varchar(50),
  [State] varchar(50),
  PostalCode varchar(50),
  Cuntry varchar(50),
  [Description] varchar(100)