在2.0正式版发布之前,就满天的看到关于DataTable支持序列化的新特性宣传,满以为从此以后使用DataTable就和DataSet一样方便了,结果在应用项目的时候才发现并非那么回事。
DataTable是支持序列化了,但是微软并没有把他做的特别方便,还需要我们自己来做一些工作之后才能够在WebService里面传递DataTable,否则在引用DataTable的时候会发现DataTable变成了一个什么Proxy类型。
首先编写类DataTableSchemaImporterExtension,代码如下:
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml.Serialization.Advanced;
using System.Collections;
using System.Xml.Schema;
using System.Xml.Serialization;
using System.CodeDom;
using System.CodeDom.Compiler;
using System.Xml;
using System.Data;
\n
namespace Xrinehart.Tools.WebService.SchemaImporter
{
class DataTableSchemaImporterExtension : SchemaImporterExtension
{
\n
// DataTableSchemaImporterExtension is used for WebServices, it is used to recognize the schema for DataTable within wsdl
\n
Hashtable importedTypes = new Hashtable();
\n
public override string ImportSchemaType(string name, string schemaNamespace, XmlSchemaObject context, XmlSchemas schemas, XmlSchemaImporter importer, CodeCompileUnit compileUnit, CodeNamespace mainNamespace, CodeGenerationOptions options, CodeDomProvider codeProvider)
{
\n
IList values = schemas.GetSchemas(schemaNamespace);
\n
if (values.Count != 1)
{
\n
return null;
\n
}
\n
XmlSchema schema = values[0] as XmlSchema;
\n
if (schema == null)
\n
return null;
\n
XmlSchemaType type = (XmlSchemaType)schema.SchemaTypes[new XmlQualifiedName(name, schemaNamespace)];
\n
return ImportSchemaType(type, context, schemas, importer, compileUnit, mainNamespace, options, codeProvider);
\n
}
\n
public override string ImportSchemaType(XmlSchemaType type, XmlSchemaObject context, XmlSchemas schemas, XmlSchemaImporter importer, CodeCompileUnit compileUnit, CodeNamespace mainNamespace, CodeGenerationOptions options, CodeDomProvider codeProvider)
{
\n
if (type == null)
{
\n
return null;
\n
}
\n
if (importedTypes[type] != null)
{
\n
mainNamespace.Imports.Add(new CodeNamespaceImport(typeof(DataSet).Namespace));
\n
compileUnit.ReferencedAssemblies.Add(“System.Data.dll”);
\n
return (string)importedTypes[type];
\n
}
\n
if (!(context is XmlSchemaElement))
\n
return null;
\n
if (type is XmlSchemaComplexType)
{
\n
XmlSchemaComplexType ct = (XmlSchemaComplexType)type;
\n
if (ct.Particle is XmlSchemaSequence)
{
\n
XmlSchemaObjectCollection items = ((XmlSchemaSequence)ct.Particle).Items;
\n
if (items.Count == 2 && items[0] is XmlSchemaAny && items[1] is XmlSchemaAny)
{
\n
XmlSchemaAny any0 = (XmlSchemaAny)items[0];
\n
XmlSchemaAny any1 = (XmlSchemaAny)items[1];
\n
if (any0.Namespace == XmlSchema.Namespace && any1.Namespace == “urn:schemas-microsoft-com:xml-diffgram-v1″)
{
\n
string typeName = typeof(DataTable).FullName;
\n
importedTypes.Add(type, typeName);
\n
mainNamespace.Imports.Add(new CodeNamespaceImport(typeof(DataTable).Namespace));
\n
compileUnit.ReferencedAssemblies.Add(“System.Data.dll”);
\n
return typeName;
\n
}
\n
}
\n
}
\n
}
\n
return null;
\n
}
\n
}
\n
}
为此类添加进一个项目中,并将此项目进行强命名后编译。
\n
然后,把该Assembly程序集加入到GAC中。
\n
最后修改本机的machine.config,代码如下:
<sectionGroup name=”system.xml.serialization” type=”System.Xml.Serialization.Configuration.SerializationSectionGroup, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″>
<section name=”schemaImporterExtensions” type=”System.Xml.Serialization.Configuration.SchemaImporterExtensionsSection, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ />
<section name=”dateTimeSerialization” type=”System.Xml.Serialization.Configuration.DateTimeSerializationSection, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ />
<section name=”xmlSerializer” type=”System.Xml.Serialization.Configuration.XmlSerializerSection, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ requirePermission=”false” />
</sectionGroup>
<system.xml.serialization>
<schemaImporterExtensions>
<add name=”dataTableSchemaImporterExtension” type=”Xrinehart.Tools.WebService.SchemaImporter.DataTableSchemaImporterExtension, Xrinehart.Tools.WebService.SchemaImporter,Version=1.0.0.0,Culture=neutral,PublicKeyToken=5a627ce15fb94702″ />
</schemaImporterExtensions>
</system.xml.serialization>
\n
完成以上的步骤后,再编译WebService,重新引用(或者更新Web引用),就可以正确的识别DataTable类型了。
其实DataTable只实现了序列化,但WebService并不能自己反序列化为可识别的格式,所以需要自己手动增加。由此可以衍生为各种业务实体BussinessEntity类对象也可以通过以上方式实现直接传递。
\n
希望对大家有所帮助。
\n
来源:网络
\n