Unicode im typ.Dataset eintragen

[Jürgen Thomas]

Hallo,

ich habe nachträglich eine <b>Firebird-DB von ISO8859_1 auf UNICODE_FSS geändert.</b> Seitdem klappt das Speichern in der DB nicht mehr. Ich vermute sehr stark, dass das <b>typisierte DataSet</b> bzw. das dafür verwendete <b>xsd-Schema</b> anzupassen ist, habe aber keine Idee für die passenden Einstellungen oder Formulierungen.

* Kann ich das <u>Schema</u> anpassen, vermutlich in folgendem Element?
<xsd:element name="dsDGW" msdata:IsDataSet="true" msdata:EnforceConstraints="False">

* Kann/Muss ich dem <u>DataSet</u> beibringen, dass die Daten als Unicode zu übertragen sind?

Ich habe keine Idee, nach welchem Begriff (außer den o.g.) ich in den 3700 Code-Zeilen suchen sollte oder welchen Eintrag ich in der xsd-Datei hinzufügen muss.

Danke für Hinweise! Jürgen

[Andreas Kosch]

Hallo,
nach jeder Änderung der Datenbank/Tabellenstruktur muss das typisierte DataSet neu aufgebaut werden. Angenommen, in der Datenbank tempdb wird das Schema einer Tabelle geändert (auch das Ändern des Zeichensatzes ist eine Schemaänderung). Das typisierte DataSet in .NET 2.0 besteht im Fall von C# aus den folgenden Dateien:

1. tempdbDataSet.xsd (vom Wizard generiert)
2. tempdbDataSet.Designer.cs (vom Wizard generiert)
3. tempdbDataSet.cs (partielle Klasse, vom Entwickler kontrolliert)

Wenn sich das Schema einer Tabelle geändert hat, muss der Wizard neu angeworfen werden, damit die Teil 1 und 2 angepasst werden. Nur der Teil 3 (partielle Klasse mit den eigenen Erweiterungen) bleibt original erhalten.

Wenn die verwendete Zugriffsklasse alle Interfaces vollständig implementiert (d.h. die Schema-Informationen der Datenbank vollständig zurückliefert), übernimmt XSD.EXE den erwarteten Zeichensatz automatisch beim erneuten Aufbau. Eine Anpassung von Hand ist im DataSet nicht notwendig.

&#10

[Jürgen Thomas]

Hallo,
OK, so etwas hatte ich mir fast gedacht. Ich habe jetzt allerdings praktische Probleme, dies zu lösen:

* In <b>VC# Express</b> kann ich <u>keine DB-Verbindung zu Firebird</u> aufbauen (und deshalb den Wizard nicht nutzen): Unter 'Datenbankverbindung hinzufügen' werden mir als Datenquelle nur Access (über OleDB) und MSSQL angeboten, obwohl u.a. FbClient in machine.config eingetragen ist; und ich finde keine VC-config o.ä., in der diese Vorgaben geändert werden könnten.

* <b>Mangels Wizard</b> hatte ich meine <u>xsd-Schemadatei teilweise manuell</u> erstellt. Es muss doch möglich sein, einen Wert dort einzutragen, der den Zeichensatz vom Standard auf Unicode ändert?! Aber welchen?

Danke für zusätzliche Hinweise! Jürge

[Andreas Kosch]

Hallo,

das Ergebnis des Visual Studio 2005-Wizards sieht folgendermaßen aus.

a) Tabelle für den MS SQL Server verwendet ANSI- und UNICODE-Spalten

<div style="font-family: Consolas; font-size: 10pt; color: black; background: white;"><p style="margin: 0px;"><span style="color: blue;">CREATE TABLE </span>TestTbl</p><p style="margin: 0px;">(</p><p style="margin: 0px;">&nbsp; id&nbsp; <span style="color: blue;">INT </span>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: blue;">NOT NULL IDENTITY PRIMARY KEY</span>,</p><p style="margin: 0px;">&nbsp; a&nbsp;&nbsp; <span style="color: blue;">VARCHAR</span>(9)&nbsp; <span style="color: blue;">NOT NULL</span>,</p><p style="margin: 0px;">&nbsp; u&nbsp;&nbsp; <span style="color: blue;">NVARCHAR</span>(9) <span style="color: blue;">NOT NULL</span></p><p style="margin: 0px;">)</p><p style="margin: 0px;">GO</p></div>

b) Die von Visual Studio 2005 generierte XSD-Datei: Unterscheidung zwischen <b>AnsiString</b> und <b>String</b>

<div style="font-family: Consolas; font-size: 10pt; color: black; background: white;"><p style="margin: 0px;"><span style="color: blue;">&lt;?</span><span style="color: maroon;">xml</span><span style="color: blue;"> </span><span style="color: red;">version</span><span style="color: blue;">=</span>"<span style="color: blue;">1.0</span>"<span style="color: blue;"> </span><span style="color: red;">encoding</span><span style="color: blue;">=</span>"<span style="color: blue;">utf-8</span>"<span style="color: blue;">?&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&lt;</span><span style="color: maroon;">xs:schema</span><span style="color: blue;"> </span><span style="color: red;">id</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdbDataSet1</span>"<span style="color: blue;"> </span><span style="color: red;">targetNamespace</span><span style="color: blue;">=</span>"<span style="color: blue;">http://tempuri.org/tempdbDataSet1.xsd</span>"<span style="color: blue;"> </span><span style="color: red;">xmlns:mstns</span><span style="color: blue;">=</span>"<span style="color: blue;">http://tempuri.org/tempdbDataSet1.xsd</span>"<span style="color: blue;"> </span><span style="color: red;">xmlns</span><span style="color: blue;">=</span>"<span style="color: blue;">http://tempuri.org/tempdbDataSet1.xsd</span>"<span style="color: blue;"> </span><span style="color: red;">xmlns:xs</span><span style="color: blue;">=</span>"<span style="color: blue;">http://www.w3.org/2001/XMLSchema</span>"<span style="color: blue;"> </span><span style="color: red;">xmlns:msdata</span><span style="color: blue;">=</span>"<span style="color: blue;">urn:schemas-microsoft-com:xml-msdata</span>"<span style="color: blue;"> </span><span style="color: red;">xmlns:msprop</span><span style="color: blue;">=</span>"<span style="color: blue;">urn:schemas-microsoft-com:xml-msprop</span>"<span style="color: blue;"> </span><span style="color: red;">attributeFormDefault</span><span style="color: blue;">=</span>"<span style="color: blue;">qualified</span>"<span style="color: blue;"> </span><span style="color: red;">elementFormDefault</span><span style="color: blue;">=</span>"<span style="color: blue;">qualified</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &lt;</span><span style="color: maroon;">xs:annotation</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:appinfo</span><span style="color: blue;"> </span><span style="color: red;">source</span><span style="color: blue;">=</span>"<span style="color: blue;">urn:schemas-microsoft-com:xml-msdatasource</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">DataSource</span><span style="color: blue;"> </span><span style="color: red;">DefaultConnectionIndex</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">FunctionsComponentName</span><span style="color: blue;">=</span>"<span style="color: blue;">QueriesTableAdapter</span>"<span style="color: blue;"> </span><span style="color: red;">Modifier</span><span style="color: blue;">=</span>"<span style="color: blue;">AutoLayout, AnsiClass, Class, Public</span>"<span style="color: blue;"> </span><span style="color: red;">SchemaSerializationMode</span><span style="color: blue;">=</span>"<span style="color: blue;">IncludeSchema</span>"<span style="color: blue;"> </span><span style="color: red;">xmlns</span><span style="color: blue;">=</span>"<span style="color: blue;">urn:schemas-microsoft-com:xml-msdatasource</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Connections</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Connection</span><span style="color: blue;"> </span><span style="color: red;">AppSettingsObjectName</span><span style="color: blue;">=</span>"<span style="color: blue;">Settings</span>"<span style="color: blue;"> </span><span style="color: red;">AppSettingsPropertyName</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdbConnectionString1</span>"<span style="color: blue;"> </span><span style="color: red;">ConnectionStringObject</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">IsAppSettingsProperty</span><span style="color: blue;">=</span>"<span style="color: blue;">True</span>"<span style="color: blue;"> </span><span style="color: red;">Modifier</span><span style="color: blue;">=</span>"<span style="color: blue;">Assembly</span>"<span style="color: blue;"> </span><span style="color: red;">Name</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdbConnectionString1 (Settings)</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterPrefix</span><span style="color: blue;">=</span>"<span style="color: blue;">@</span>"<span style="color: blue;"> </span><span style="color: red;">PropertyReference</span><span style="color: blue;">=</span>"<span style="color: blue;">ApplicationSettings.TypisiertesDataSetUnico deUnterschied.Properties.Settings.GlobalReference. Default.tempdbConnectionString1</span>"<span style="color: blue;"> </span><span style="color: red;">Provider</span><span style="color: blue;">=</span>"<span style="color: blue;">System.Data.SqlClient</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Connection</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Connections</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Tables</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">TableAdapter</span><span style="color: blue;"> </span><span style="color: red;">BaseClass</span><span style="color: blue;">=</span>"<span style="color: blue;">System.ComponentModel.Component</span>"<span style="color: blue;"> </span><span style="color: red;">DataAccessorModifier</span><span style="color: blue;">=</span>"<span style="color: blue;">AutoLayout, AnsiClass, Class, Public</span>"<span style="color: blue;"> </span><span style="color: red;">DataAccessorName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblTableAdapter</span>"<span style="color: blue;"> </span><span style="color: red;">GeneratorDataComponentClassName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblTableAdapter</span>"<span style="color: blue;"> </span><span style="color: red;">Name</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTbl</span>"<span style="color: blue;"> </span><span style="color: red;">UserDataComponentName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblTableAdapter</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">MainSource</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">DbSource</span><span style="color: blue;"> </span><span style="color: red;">ConnectionRef</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdbConnectionString1 (Settings)</span>"<span style="color: blue;"> </span><span style="color: red;">DbObjectName</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdb.dbo.TestTbl</span>"<span style="color: blue;"> </span><span style="color: red;">DbObjectType</span><span style="color: blue;">=</span>"<span style="color: blue;">Table</span>"<span style="color: blue;"> </span><span style="color: red;">FillMethodModifier</span><span style="color: blue;">=</span>"<span style="color: blue;">Public</span>"<span style="color: blue;"> </span><span style="color: red;">FillMethodName</span><span style="color: blue;">=</span>"<span style="color: blue;">Fill</span>"<span style="color: blue;"> </span><span style="color: red;">GenerateMethods</span><span style="color: blue;">=</span>"<span style="color: blue;">Both</span>"<span style="color: blue;"> </span><span style="color: red;">GenerateShortCommands</span><span style="color: blue;">=</span>"<span style="color: blue;">True</span>"<span style="color: blue;"> </span><span style="color: red;">GeneratorGetMethodName</span><span style="color: blue;">=</span>"<span style="color: blue;">GetData</span>"<span style="color: blue;"> </span><span style="color: red;">GeneratorSourceName</span><span style="color: blue;">=</span>"<span style="color: blue;">Fill</span>"<span style="color: blue;"> </span><span style="color: red;">GetMethodModifier</span><span style="color: blue;">=</span>"<span style="color: blue;">Public</span>"<span style="color: blue;"> </span><span style="color: red;">GetMethodName</span><span style="color: blue;">=</span>"<span style="color: blue;">GetData</span>"<span style="color: blue;"> </span><span style="color: red;">QueryType</span><span style="color: blue;">=</span>"<span style="color: blue;">Rowset</span>"<span style="color: blue;"> </span><span style="color: red;">ScalarCallRetval</span><span style="color: blue;">=</span>"<span style="color: blue;">System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</span>"<span style="color: blue;"> </span><span style="color: red;">UseOptimisticConcurrency</span><span style="color: blue;">=</span>"<span style="color: blue;">True</span>"<span style="color: blue;"> </span><span style="color: red;">UserGetMethodName</span><span style="color: blue;">=</span>"<span style="color: blue;">GetData</span>"<span style="color: blue;"> </span><span style="color: red;">UserSourceName</span><span style="color: blue;">=</span>"<span style="color: blue;">Fill</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">DeleteCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">DbCommand</span><span style="color: blue;"> </span><span style="color: red;">CommandType</span><span style="color: blue;">=</span>"<span style="color: blue;">Text</span>"<span style="color: blue;"> </span><span style="color: red;">ModifiedByUser</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span>DELETE FROM [dbo].[TestTbl] WHERE (([id] = @Original_id) AND ([a] = @Original_a) AND ([u] = @Original_u))<span style="color: blue;">&lt;/</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">Int32</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@Original_id</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">Int</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Original</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">AnsiString</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@Original_a</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">VarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Original</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">String</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@Original_u</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">NVarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Original</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">DbCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">DeleteCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">InsertCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">DbCommand</span><span style="color: blue;"> </span><span style="color: red;">CommandType</span><span style="color: blue;">=</span>"<span style="color: blue;">Text</span>"<span style="color: blue;"> </span><span style="color: red;">ModifiedByUser</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span>INSERT INTO [dbo].[TestTbl] ([a], [u]) VALUES (@a, @u);</p><p style="margin: 0px;">SELECT id, a, u FROM TestTbl WHERE (id = SCOPE_IDENTITY())<span style="color: blue;">&lt;/</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">AnsiString</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@a</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">VarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Current</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">String</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@u</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">NVarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Current</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">DbCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">InsertCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">SelectCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">DbCommand</span><span style="color: blue;"> </span><span style="color: red;">CommandType</span><span style="color: blue;">=</span>"<span style="color: blue;">Text</span>"<span style="color: blue;"> </span><span style="color: red;">ModifiedByUser</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span>SELECT id, a, u FROM dbo.TestTbl<span style="color: blue;">&lt;/</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">DbCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">SelectCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">UpdateCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">DbCommand</span><span style="color: blue;"> </span><span style="color: red;">CommandType</span><span style="color: blue;">=</span>"<span style="color: blue;">Text</span>"<span style="color: blue;"> </span><span style="color: red;">ModifiedByUser</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span>UPDATE [dbo].[TestTbl] SET [a] = @a, [u] = @u WHERE (([id] = @Original_id) AND ([a] = @Original_a) AND ([u] = @Original_u));</p><p style="margin: 0px;">SELECT id, a, u FROM TestTbl WHERE (id = @id)<span style="color: blue;">&lt;/</span><span style="color: maroon;">CommandText</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">AnsiString</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@a</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">VarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Current</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">String</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@u</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">NVarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Current</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">Int32</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@Original_id</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">Int</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Original</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">AnsiString</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@Original_a</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">VarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Original</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>""<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">String</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@Original_u</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">NVarChar</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Original</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Parameter</span><span style="color: blue;"> </span><span style="color: red;">AllowDbNull</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">AutogeneratedName</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">ColumnName</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">DataSourceName</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdb.dbo.TestTbl</span>"<span style="color: blue;"> </span><span style="color: red;">DataTypeServer</span><span style="color: blue;">=</span>"<span style="color: blue;">int</span>"<span style="color: blue;"> </span><span style="color: red;">DbType</span><span style="color: blue;">=</span>"<span style="color: blue;">Int32</span>"<span style="color: blue;"> </span><span style="color: red;">Direction</span><span style="color: blue;">=</span>"<span style="color: blue;">Input</span>"<span style="color: blue;"> </span><span style="color: red;">ParameterName</span><span style="color: blue;">=</span>"<span style="color: blue;">@id</span>"<span style="color: blue;"> </span><span style="color: red;">Precision</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">ProviderType</span><span style="color: blue;">=</span>"<span style="color: blue;">Int</span>"<span style="color: blue;"> </span><span style="color: red;">Scale</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">Size</span><span style="color: blue;">=</span>"<span style="color: blue;">4</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">SourceColumnNullMapping</span><span style="color: blue;">=</span>"<span style="color: blue;">False</span>"<span style="color: blue;"> </span><span style="color: red;">SourceVersion</span><span style="color: blue;">=</span>"<span style="color: blue;">Current</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Parameters</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">DbCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">UpdateCommand</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">DbSource</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">MainSource</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Mappings</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Mapping</span><span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">DataSetColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Mapping</span><span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">DataSetColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Mapping</span><span style="color: blue;"> </span><span style="color: red;">SourceColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">DataSetColumn</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Mappings</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Sources</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Sources</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">TableAdapter</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Tables</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">Sources</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">Sources</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">DataSource</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:appinfo</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &lt;/</span><span style="color: maroon;">xs:annotation</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &lt;</span><span style="color: maroon;">xs:element</span><span style="color: blue;"> </span><span style="color: red;">name</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdbDataSet1</span>"<span style="color: blue;"> </span><span style="color: red;">msdata:IsDataSet</span><span style="color: blue;">=</span>"<span style="color: blue;">true</span>"<span style="color: blue;"> </span><span style="color: red;">msdata:UseCurrentLocale</span><span style="color: blue;">=</span>"<span style="color: blue;">true</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_UserDSName</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdbDataSet1</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_DataSetName</span><span style="color: blue;">=</span>"<span style="color: blue;">tempdbDataSet1</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:complexType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:choice</span><span style="color: blue;"> </span><span style="color: red;">minOccurs</span><span style="color: blue;">=</span>"<span style="color: blue;">0</span>"<span style="color: blue;"> </span><span style="color: red;">maxOccurs</span><span style="color: blue;">=</span>"<span style="color: blue;">unbounded</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:element</span><span style="color: blue;"> </span><span style="color: red;">name</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTbl</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_UserTableName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTbl</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_RowDeletedName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblRowDeleted</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_TableClassName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblDataTable</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_RowChangedName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblRowChanged</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_RowClassName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblRow</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_RowChangingName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblRowChanging</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_RowEvArgName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblRowChangeEvent</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_RowEvHandlerName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblRowChangeEventHandler</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_TablePropName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTbl</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_TableVarName</span><span style="color: blue;">=</span>"<span style="color: blue;">tableTestTbl</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_RowDeletingName</span><span style="color: blue;">=</span>"<span style="color: blue;">TestTblRowDeleting</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:complexType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:sequence</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:element</span><span style="color: blue;"> </span><span style="color: red;">name</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">msdata:ReadOnly</span><span style="color: blue;">=</span>"<span style="color: blue;">true</span>"<span style="color: blue;"> </span><span style="color: red;">msdata:AutoIncrement</span><span style="color: blue;">=</span>"<span style="color: blue;">true</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_UserColumnName</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnPropNameInRow</span><span style="color: blue;">=</span>"<span style="color: blue;">id</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnVarNameInTable</span><span style="color: blue;">=</span>"<span style="color: blue;">columnid</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnPropNameInTable</span><span style="color: blue;">=</span>"<span style="color: blue;">idColumn</span>"<span style="color: blue;"> </span><span style="color: red;">type</span><span style="color: blue;">=</span>"<span style="color: blue;">xs:int</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:element</span><span style="color: blue;"> </span><span style="color: red;">name</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_UserColumnName</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnPropNameInRow</span><span style="color: blue;">=</span>"<span style="color: blue;">a</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnVarNameInTable</span><span style="color: blue;">=</span>"<span style="color: blue;">columna</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnPropNameInTable</span><span style="color: blue;">=</span>"<span style="color: blue;">aColumn</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:simpleType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:restriction</span><span style="color: blue;"> </span><span style="color: red;">base</span><span style="color: blue;">=</span>"<span style="color: blue;">xs:string</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:maxLength</span><span style="color: blue;"> </span><span style="color: red;">value</span><span style="color: blue;">=</span>"<span style="color: blue;">9</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:restriction</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:simpleType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:element</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:element</span><span style="color: blue;"> </span><span style="color: red;">name</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_UserColumnName</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnPropNameInRow</span><span style="color: blue;">=</span>"<span style="color: blue;">u</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnVarNameInTable</span><span style="color: blue;">=</span>"<span style="color: blue;">columnu</span>"<span style="color: blue;"> </span><span style="color: red;">msprop:Generator_ColumnPropNameInTable</span><span style="color: blue;">=</span>"<span style="color: blue;">uColumn</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:simpleType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:restriction</span><span style="color: blue;"> </span><span style="color: red;">base</span><span style="color: blue;">=</span>"<span style="color: blue;">xs:string</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:maxLength</span><span style="color: blue;"> </span><span style="color: red;">value</span><span style="color: blue;">=</span>"<span style="color: blue;">9</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:restriction</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:simpleType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:element</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:sequence</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:complexType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:element</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:choice</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:complexType</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:unique</span><span style="color: blue;"> </span><span style="color: red;">name</span><span style="color: blue;">=</span>"<span style="color: blue;">Constraint1</span>"<span style="color: blue;"> </span><span style="color: red;">msdata:PrimaryKey</span><span style="color: blue;">=</span>"<span style="color: blue;">true</span>"<span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:selector</span><span style="color: blue;"> </span><span style="color: red;">xpath</span><span style="color: blue;">=</span>"<span style="color: blue;">.//mstns:TestTbl</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &nbsp; &lt;</span><span style="color: maroon;">xs:field</span><span style="color: blue;"> </span><span style="color: red;">xpath</span><span style="color: blue;">=</span>"<span style="color: blue;">mstns:id</span>"<span style="color: blue;"> /&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &nbsp; &lt;/</span><span style="color: maroon;">xs:unique</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&nbsp; &lt;/</span><span style="color: maroon;">xs:element</span><span style="color: blue;">&gt;</span></p><p style="margin: 0px;"><span style="color: blue;">&lt;/</span><span style="color: maroon;">xs:schema</span><span style="color: blue;">&gt;</span></p></div>

c) Die Anbindung im TableAdapter: Unterscheidung zwischen <b>System.Data.SqlDbType.VarChar</b> und <b>System.Data.SqlDbType.NVarChar</b>

<div style="font-family: Consolas; font-size: 10pt; color: black; background: white;"><p style="margin: 0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: blue;">this</span>._adapter.InsertCommand = <span style="color: blue;">new</span> System.Data.SqlClient.<span style="color: teal;">SqlCommand</span>();</p><p style="margin: 0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: blue;">this</span>._adapter.InsertCommand.Connection = <span style="color: blue;">this</span>.Connection;</p><p style="margin: 0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: blue;">this</span>._adapter.InsertCommand.CommandText = <span style="color: maroon;">"INSERT INTO [dbo].[TestTbl] ([a], [u]) VALUES (@a, @u);\r\nSELECT id, a, u FROM Tes"</span> +</p><p style="margin: 0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: maroon;">"tTbl WHERE (id = SCOPE_IDENTITY())"</span>;</p><p style="margin: 0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: blue;">this</span>._adapter.InsertCommand.CommandType = System.Data.<span style="color: teal;">CommandType</span>.Text;</p><p style="margin: 0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: blue;">this</span>._adapter.InsertCommand.Parameters.Add(<span style="color: blue;">new</span> System.Data.SqlClient.<span style="color: teal;">SqlParameter</span>(<span style="color: maroon;">"@a"</span>, System.Data.<span style="color: teal;">SqlDbType</span>.VarChar, 0, System.Data.<span style="color: teal;">ParameterDirection</span>.Input, 0, 0, <span style="color: maroon;">"a"</span>, System.Data.<span style="color: teal;">DataRowVersion</span>.Current, <span style="color: blue;">false</span>, <span style="color: blue;">null</span>, <span style="color: maroon;">""</span>, <span style="color: maroon;">""</span>, <span style="color: maroon;">""</span>));</p><p style="margin: 0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="color: blue;">this</span>._adapter.InsertCommand.Parameters.Add(<span style="color: blue;">new</span> System.Data.SqlClient.<span style="color: teal;">SqlParameter</span>(<span style="color: maroon;">"@u"</span>, System.Data.<span style="color: teal;">SqlDbType</span>.NVarChar, 0, System.Data.<span style="color: teal;">ParameterDirection</span>.Input, 0, 0, <span style="color: maroon;">"u"</span>, System.Data.<span style="color: teal;">DataRowVersion</span>.Current, <span style="color: blue;">false</span>, <span style="color: blue;">null</span>, <span style="color: maroon;">""</span>, <span style="color: maroon;">""</span>, <span style="color: maroon;">""</span>));</p></div&gt