I have been developing a Silverlight WCF RIA Services application dealing with mock financial transactions. To more efficiently send summary data to the client without going overboard with serialized entities I have created a summary class that isn’t in my EDM, and figured out how to serialize and send it over the wire to the SL client using DataContract() and DataMember(). Everything seemed to be working out great, until I tried to bind
controls to a list inside my custom object. The list seems to always get deserialized with an extra, almost empty entity in it that I don’t know how to get rid of. So, here are some of the pieces.
First the relevant bits from the custom object class:
<DataContract()> _
Public Class EconomicsSummary
Public Sub New()
RecentTransactions = New List(Of Transaction)
TotalAccountHistory = New List(Of Transaction)
End Sub
Public Sub New(ByVal enUser As EntityUser)
Me.UserId = enUser.UserId
Me.UserName = enUser.UserName
Me.Accounts = enUser.Accounts
Me.Jobs = enUser.Jobs
RecentTransactions = New List(Of Transaction)
TotalAccountHistory = New List(Of Transaction)
End Sub
<DataMember()> _
<Key()> _
Public Property UserId As System.Guid
<DataMember()> _
Public Property NumTransactions As Integer
<DataMember()> _
<Include()> _
<Association("Summary_RecentTransactions", "UserId", "User_UserId")> _
Public Property RecentTransactions As List(Of Transaction)
<DataMember()> _
<Include()> _
<Association("Summary_TotalAccountHistory", "UserId", "User_UserId")> _
Public Property TotalAccountHistory As List(Of Transaction)
End Class
Next, the relevant parts of the function called to return the object:
Public Function GetEconomicsSummary(ByVal guidUserId As System.Guid) As EconomicsSummary
Dim objOutput As New EconomicsSummary(enUser)
For Each objTransaction As Transaction In (From t As Transaction In Me.ObjectContext.Transactions.Include("Account") Where t.Account.aspnet_User_UserId = guidUserId Select t Order By t.TransactionDate Descending Take 10)
objTransaction.User_UserId = objOutput.UserId
objOutput.RecentTransactions.Add(objTransaction)
Next
objOutput.NumTransactions = objOutput.RecentTransactions.Count
…
Return objOutput
End Function
Notice that I’m collecting the NumTransactions count before serialization. Should be 10 right? It is – BEFORE serialization.
The DataGrid is bound to the data source as follows:
<sdk:DataGrid AutoGenerateColumns="False" Height="100" MaxWidth="{Binding ElementName=aciSummary, Path=ActualWidth}"
ItemsSource="{Binding Source={StaticResource EconomicsSummaryRecentTransactionsViewSource}, Mode=OneWay}"
Name="gridRecentTransactions" RowDetailsVisibilityMode="VisibleWhenSelected" IsReadOnly="True">
<sdk:DataGrid.Columns>
<sdk:DataGridTextColumn x:Name="TransactionDateColumn" Binding="{Binding Path=TransactionDate, StringFormat=\{0:d\}}" Header="Date" Width="SizeToHeader" />
<sdk:DataGridTextColumn x:Name="AccountNameColumn" Binding="{Binding Path=Account.Title}" Header="Account" Width="SizeToCells" />
<sdk:DataGridTextColumn x:Name="CurrencyAmountColumn" Binding="{Binding Path=CurrencyAmount, StringFormat=\{0:c\}}" Header="Amount" Width="SizeToHeader" />
<sdk:DataGridTextColumn x:Name="TitleColumn" Binding="{Binding Path=Title}" Header="Description" Width="SizeToCells" />
<sdk:DataGridTextColumn x:Name="ItemQuantityColumn" Binding="{Binding Path=ItemQuantity}" Header="Qty" Width="SizeToHeader" />
</sdk:DataGrid.Columns>
</sdk:DataGrid>
You might be wondering where the ItemsSource is coming from, that looks like this:
<CollectionViewSource x:Key="EconomicsSummaryRecentTransactionsViewSource" Source="{Binding Path=DataView.RecentTransactions, ElementName=EconomicsSummaryDomainDataSource}" />
When I noticed that the DataGrid had the extra row I tried outputting some data after the data source finishes loading, as follows:
Private Sub EconomicsSummaryDomainDataSource_LoadedData(ByVal sender As System.Object, ByVal e As System.Windows.
Controls.LoadedDataEventArgs) Handles EconomicsSummaryDomainDataSource.LoadedData
If e.HasError Then
System.Windows.MessageBox.Show(e.Error.ToString, "Load Error", System.Windows.MessageBoxButton.OK)
e.MarkErrorAsHandled()
End If
Dim objSummary As EconomicsSummary = CType(EconomicsSummaryDomainDataSource.Data(0), EconomicsSummary)
Dim sb As New StringBuilder("")
sb.AppendLine(String.Format("Num Transactions: {0} ({1})", objSummary.RecentTransactions.Count.ToString(), objSummary.NumTransactions.ToString()))
For Each objTransaction As Transaction In objSummary.RecentTransactions
sb.AppendLine(String.Format("Recent TransactionId {0} dated {1} CurrencyAmount {2} NewBalance {3}", objTransaction.TransactionId.ToString, objTransaction.TransactionDate.ToString("d"), objTransaction.CurrencyAmount.ToString("c"), objTransaction.NewBalance.ToString("c")))
Next
txtDebug.Text = sb.ToString()
End Sub
Output from that looks like this:
Num Transactions: 11 (10)
Recent TransactionId 2283 dated 6/1/2010 CurrencyAmount $31.00 NewBalance $392.00
Recent TransactionId 2281 dated 5/31/2010 CurrencyAmount $33.00 NewBalance $361.00
Recent TransactionId 2279 dated 5/28/2010 CurrencyAmount $8.00 NewBalance $328.00
Recent TransactionId 2277 dated 5/26/2010 CurrencyAmount $22.00 NewBalance $320.00
Recent TransactionId 2275 dated 5/24/2010 CurrencyAmount $5.00 NewBalance $298.00
Recent TransactionId 2273 dated 5/21/2010 CurrencyAmount $19.00 NewBalance $293.00
Recent TransactionId 2271 dated 5/20/2010 CurrencyAmount $20.00 NewBalance $274.00
Recent TransactionId 2269 dated 5/19/2010 CurrencyAmount $48.00 NewBalance $254.00
Recent TransactionId 2267 dated 5/18/2010 CurrencyAmount $42.00 NewBalance $206.00
Recent TransactionId 2265 dated 5/14/2010 CurrencyAmount $5.00 NewBalance $164.00
Recent TransactionId 0 dated 6/1/2010 CurrencyAmount $0.00 NewBalance $361.00
So I have a few different questions:
-First and foremost, where the devil is that extra Transaction entity coming from and how do I get rid of it? Does it have anything to do with the other list of Transaction entities being serialized as part of the EconomicsSummary class (TotalAccountHistory)? Do I need to decorate the EconomicsSummary class members a little more/differently?
-Second, where are the peculiar values coming from on that extra entity?
PRE-POSTING UPDATE 1: I did a little checking, it looks like that last entry is the first one in the TotalAccountHistory list. Do I need to do something with CollectionDataContract()?
PRE-POSTING UPDATE 2: I fixed one bug in TotalAccountHistory, since the objects weren’t coming from the database their keys weren’t unique. So I set the keys on the Transaction entities inside TotalAccountHistory to be unique and guess what? Now, after deserialization RecentTransactions contains all its original items, plus every item in TotalAccountHistory. I’m pretty sure this has to do with the deserializer getting confused by two collections of the same type. But I don’t yet know how to resolve it…
