none
Table Adapter Issue RRS feed

  • Question

  • Hi All

    We are developing DDEX provider for our datasource. The MS sql query to access the first 5 rows from table is

    "select top 5 * from employees" the smilar query to acees the rows from our databse is "select * from employees limit to 5 rows"

    The table adapter parse the query "select top 5 * from employees" without any issue but While parsing the query ie ""select * from employees limit to 5 rows" the table adapter is throwing exception. As per my understanding the table adapter doesnt know the key words "LIMIT" "TO" "ROWS",but these keywords are vaild for our database.

    Please suggest me how I can make my table adapter to undestand these keywords, so that it should not give syntax error while parsing the query. I searched is sample ddex code provided by MSDN but i did not find the way to do this.

    Please suggest me.

    Thanks,

    Prash

    • Changed type VMazurModerator Wednesday, December 1, 2010 11:21 AM
    • Moved by VMazurModerator Wednesday, December 1, 2010 11:25 AM (From:ADO.NET Managed Providers)
    Tuesday, November 30, 2010 2:50 PM