locked
Going "all the way" with ObservableCollection RRS feed

  • Question

  • Hi guys,

    I have been using .NET since the original Alpha and one of the biggest hassles I have is getting data changed events to visible controls. This, to a major degree, has been solved with the ObservableCollection (Fantastic - thankyou). However, this wasn't the area of 'hurt' that needed attention (In my humble opinion).

    The hardest task, is getting Trigger Events from SQL Server to the underlying collection.

    I prefer to have a table ready to publish for live data presentation (This allows fast, easy access to data for presentation) and essentially 'bind' that table for presentation. All changes are made to the repository from external events (Generally by Windows Service).

    What would be EXCELLENT would be to be able to underly the ObservableCollection with a direct table connection which reflects live data changes to the collection.

    I have tried with a CLR WCF, however, SQL Server does not allow this to happen. It seems that "any .Net assembly can be hosted in SQL Server CLR" is not correct at all.

    Any thoughts?

    Sunday, January 23, 2011 11:43 PM

All replies

  •  

    Hi Apteryx,

     

    Sorry for the late reply.

     

    If I understand correctly, you want to find a way to establish a two-way connection between ObservableCollection and a SQL Server database table, am I right?


    Eric Yang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, January 25, 2011 10:22 AM
  • Absolutley - is that possible without trying to embed wcf in the SQL CLR?
    Thursday, January 27, 2011 8:39 AM
  •  

    Sorry for my late reply, I'm not sure whether such mechanism exists, but you may try .NET Framework inside SQL Server forum for further support.

     

    Please feel free to let us know if you have any concern.


    Eric Yang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, February 2, 2011 2:14 AM