This is a migrated thread and some comments may be shown as answers.

Reg: PIVOT GRID Custome View Save

1 Answer 37 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Chakri
Top achievements
Rank 1
Chakri asked on 08 Mar 2018, 08:26 AM

Hello Team,

We are into the WPF application development. We are using the RadPivotGrid control to view the information grid. To view the same BI format we are saving the  view(i.e in XML format). When we save the view. our application is saving the data in our database in XML format. Please review the attached file which is saved in xml format. But we want to know the what is the <ValueTypes> node which is created while saving the view. We want to know what is the version number saved in the file. Is there any relation with .net framework version while generating the XML string?

Below is the XML string.

<?xml version="1.0"?>
<RawData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SerializationString>&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;Data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
  &lt;T&gt;
    &lt;TI K="1984105613" N="Telerik.Pivot.Core.LocalDataSourceProvider, Telerik.Pivot.Core, Version=2014.2.729.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7" /&gt;
  &lt;/T&gt;
  &lt;P&gt;
    &lt;PV Key="1" TypeKey="-664072138"&gt;
      &lt;Value xsi:type="xsd:string"&gt;&amp;lt;DataProviderSettings xmlns="http://schemas.datacontract.org/2004/07/AIMSDotNet" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"&amp;gt;&amp;lt;Aggregates xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"&amp;gt;&amp;lt;a:anyType i:type="b:PropertyAggregateDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:TotalFormat i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Totals"/&amp;gt;&amp;lt;b:StringFormat i:nil="true"/&amp;gt;&amp;lt;b:StringFormatSelector i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Aggregates"/&amp;gt;&amp;lt;b:AggregateFunction i:type="b:SumAggregateFunction" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Aggregates"/&amp;gt;&amp;lt;b:PropertyName&amp;gt;Stock&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;/Aggregates&amp;gt;&amp;lt;AggregatesLevel&amp;gt;0&amp;lt;/AggregatesLevel&amp;gt;&amp;lt;AggregatesPosition&amp;gt;Rows&amp;lt;/AggregatesPosition&amp;gt;&amp;lt;Columns xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;WarehouseCode&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;/Columns&amp;gt;&amp;lt;Filters xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/&amp;gt;&amp;lt;Rows xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;StyleDescription&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;ColorDescription&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;Size&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;/Rows&amp;gt;&amp;lt;/DataProviderSettings&amp;gt;&lt;/Value&gt;
    &lt;/PV&gt;
  &lt;/P&gt;
  &lt;R&gt;
    &lt;RV Key="21184986" IsRoot="true" TypeKey="1984105613"&gt;
      &lt;D&gt;
        &lt;PD PN="" VK="1" RK="0" TK="1984105613" TCK="0" /&gt;
      &lt;/D&gt;
    &lt;/RV&gt;
  &lt;/R&gt;
&lt;/Data&gt;</SerializationString>
  <ValueTypes>
    <string>Telerik.Pivot.Core.LocalDataSourceProvider, Telerik.Pivot.Core, Version=2014.2.729.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7</string>
  </ValueTypes>
</RawData>

We want to know what is the significance of the  version number(i.e Version=2014.2.729.45) in the below context? 

  <ValueTypes>
    <string>Telerik.Pivot.Core.LocalDataSourceProvider, Telerik.Pivot.Core, Version=2014.2.729.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7</string>
  </ValueTypes>
</RawData>

Following are the software specifications

OS: WINDOWS 10

.Net Framework: 4.6.2

Telerik Version: 14.2.729.0

 

Regards,

Chakradhar

 

 

1 Answer, 1 is accepted

Sort by
0
Dilyan Traykov
Telerik team
answered on 12 Mar 2018, 12:22 PM
Hello Chakri,

By default, when the persistence framework saves a type it also saves its assembly's version and when deserializing it tries to get this exact same type (with the same version). We do this because there might be breaking changes between the different dll versions and the framework might not be able to load the properties correctly.

This information is used by the AllowCrossVersion property of the PersistenceManager class. Please note, however, that it only works for the assemblies from the UI for WPF suite.

I hope that this sheds some light on the matter. Should any follow up questions or concerns arise, do not hesitate to contact me again.

Regards,
Dilyan Traykov
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
Tags
PivotGrid
Asked by
Chakri
Top achievements
Rank 1
Answers by
Dilyan Traykov
Telerik team
Share this question
or