Интересно, все ваши "Сообщений: 31507" сообщений все такого рода - Неправда, правда, да, нет и т.д.?
Люди часто пишут неправду. И да, "DataSet и Fill - но это же функции MS SQL" - тоже неправда:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
using(var cnn = new OracleConnection("..."))
using(var cmd = new OracleCommand("select * from dba_tab_columns where rownum=1", cnn))
{
cnn.Open();
using(var adapter = new OracleDataAdapter(cmd))
{
var ds = new DataSet();
adapter.Fill(ds);
using(var xw = XmlWriter.Create(Console.Out, new XmlWriterSettings
{
Indent = true,
IndentChars = " ",
OmitXmlDeclaration = true
}))
ds.WriteXml(xw, XmlWriteMode.IgnoreSchema);
}
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
<NewDataSet>
<Table>
<OWNER>SYS</OWNER>
<TABLE_NAME>UNDO$</TABLE_NAME>
<COLUMN_NAME>US#</COLUMN_NAME>
<DATA_TYPE>NUMBER</DATA_TYPE>
<DATA_LENGTH>22</DATA_LENGTH>
<NULLABLE>N</NULLABLE>
<COLUMN_ID>1</COLUMN_ID>
<NUM_DISTINCT>18</NUM_DISTINCT>
<LOW_VALUE>gA==</LOW_VALUE>
<HIGH_VALUE>wRI=</HIGH_VALUE>
<DENSITY>0.0555555555555556</DENSITY>
<NUM_NULLS>0</NUM_NULLS>
<NUM_BUCKETS>1</NUM_BUCKETS>
<LAST_ANALYZED>2020-07-14T22:00:54+05:00</LAST_ANALYZED>
<SAMPLE_SIZE>18</SAMPLE_SIZE>
<GLOBAL_STATS>YES</GLOBAL_STATS>
<USER_STATS>NO</USER_STATS>
<AVG_COL_LEN>3</AVG_COL_LEN>
<CHAR_LENGTH>0</CHAR_LENGTH>
<V80_FMT_IMAGE>NO</V80_FMT_IMAGE>
<DATA_UPGRADED>YES</DATA_UPGRADED>
<HISTOGRAM>NONE</HISTOGRAM>
<DEFAULT_ON_NULL>NO</DEFAULT_ON_NULL>
<IDENTITY_COLUMN>NO</IDENTITY_COLUMN>
<SENSITIVE_COLUMN>NO</SENSITIVE_COLUMN>
</Table>
</NewDataSet>
