Category: XML

01 Oct 2013 00:02

Joined:	06/11/2008
Level:	Gold
Points:	433

Points:	2

How to generate table script from XSD files in .net ?

Are you looking for a way to generate table script from XSD files in .net ? then read this thread to know more about it

Hi All,
I just want to try to do this in .net code . Code will return table scripts taking input as XSD file info. This is possible by using XML spy , but whether it can be done using .net ?
Thanks
R R Mishra

#729500

01 Oct 2013 05:58

Joined:	17/03/2009
Level:	Gold
Points:	2282

Points:	3

Hi,

Check the below links

http://www.codeproject.com/Articles/76814/Generate-SQL-Database-Schema-from-XML-Part-1-File

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/fca0892d-78d3-4469-a4b0-f21eede688f5/can-i-create-a-database-schema-from-a-dataset-andor-xsd-file

http://stackoverflow.com/questions/11656324/how-can-i-generate-create-table-script-from-code

#729876

05 Oct 2013 10:35

Joined:	30/04/2012
Level:	Gold
Points:	7233

Points:	4

You can use this code snippet for generate Table Script from XSD

<#PrepareToRender(); #>

<#

foreach (DataTable Data1 in dset.Tables) {

tableName= data1.ToString();

#>

CREATE TABLE <#= YourtableName #>

(

<#

PushIndent(" ");
foreach (DataColumn dsoc in data1.Columns) {
WriteLine( dsoc.ToString() + " " + MapToSqlType(dsoc.DataType.Name) + ",");
}
PopIndent();
#>
)
<#

}

#>

<#+

DataSet dset;
string tableName;
void PrepareToRender()
{
dset = new System.Data.DataSet();
dset.ReadXmlSchema("Metadata.xsd");
}
string MapToSqlType(string clrType)
{
switch(clrType)
{
case "String":
return "Varchar(50)";
case "Int32":
return "int";
default:
return clrType;

}
}
#>

How to generate table script from XSD files in .net ?

About dotnetspider.com

Quick Links

General

Services