none
LinqDataSource - problem with insert/update/delete RRS feed

  • Question

  •  

    Can anyone see a workaround for this very annoying problem?? I'm getting the error

     

    The table property used by LinqDataSource 'LinqDataSource1' must extend Table<T> when the Delete, Insert or Update operations are enabled.

     

    I have rewritten the datalayer of my application to use LINQ to SQL. As LINQ-to-SQL has no object access security I've added this using the TableView from Keith Farmer's blog.  This works fantastically well for querying the data, because his TableView class implements ITable, and inserts/updates work fine from code.

     

    However, it seems LinqDataSource doesn't care if it support ITable or not, it wants something Table<T> - so I cannot use my secure DataContext for updates/inserts/deletes.

     

    Is there any way around this?

    Monday, June 16, 2008 4:56 PM
    Answerer

Answers

  • The LinqDataSource is actually owned and supported by the ASP.NET team so you may like to post your question over at their forums at http://forums.asp.net as they do not actively monitor this forum.

     

    That isn't to say somebody here can't help - we have a lot of great contributors here Smile but it's outside of the core team expertise.

     

    [)amien

     

     

     

    Monday, June 16, 2008 10:17 PM
    Moderator

All replies

  • The LinqDataSource is actually owned and supported by the ASP.NET team so you may like to post your question over at their forums at http://forums.asp.net as they do not actively monitor this forum.

     

    That isn't to say somebody here can't help - we have a lot of great contributors here Smile but it's outside of the core team expertise.

     

    [)amien

     

     

     

    Monday, June 16, 2008 10:17 PM
    Moderator
  • Thanks - will do

    Tuesday, June 17, 2008 7:44 AM
    Answerer