Support Xml in MSSQL

Discussion of open issues, suggestions and bugs regarding EntityDAC
Post Reply
Vlastelin
Posts: 2
Joined: Tue 22 Jan 2019 14:59

Support Xml in MSSQL

Post by Vlastelin » Tue 22 Jan 2019 15:12

I use TFireDACDataProvider.

Code: Select all

var Doc := FMyContext.Document;
var Query := Linq.From(Doc).Select([Doc.XmlOriginal]).Take(1); // XmlOriginal Field in MSSQL is XML
EntityDataSet1.SourceCollection := FStingray.GetEntities(Query);
EntityDataSet1.Open; // this error EProviderException with message '[TFieldProvider] Unsupported data type for the XmlOriginal field: ftDBaseOle'
I tried

Code: Select all

[Column('XmlOriginal')]
FXmlOriginal: TXMLData;
and

Code: Select all

[Column('XmlOriginal')]
FXmlOriginal: string;

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Support Xml in MSSQL

Post by MaximG » Wed 23 Jan 2019 16:44

Thank you for the information. We will investigate the described issue and let you know the results shortly.

Vlastelin
Posts: 2
Joined: Tue 22 Jan 2019 14:59

Re: Support Xml in MSSQL

Post by Vlastelin » Tue 05 Feb 2019 09:24

Any results?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Support Xml in MSSQL

Post by MaximG » Tue 05 Feb 2019 12:12

We have started the implementation and look forward to receiving results quickly, of which we will immediately notify you

Post Reply