How to change DbSyncTableDescription quote character RRS feed

  • Question

  • When I assign a table name to DbSyncTableDescription.LocalName , the table name get wrapped with [] quote characters. For example when I assign orders table name to LocalName the quoted table name is [orders]. How do I change [] quote characters to "” (double quote character)? (I want LocalName to be "orders" instead of [orders])

    Tuesday, December 7, 2010 8:24 AM

All replies

  • i dont think you can override it as it is hardcoded inside Sync Fx. any particular issue you're having with the [] characters?
    Tuesday, December 7, 2010 3:40 PM
  • Thanks.

    We are writing a provider for a db that doesn't support []. Documentation says LocalName property - Gets or sets the name, including database-specific delimiters. So thought there may be a way to override default [].

    Tuesday, December 7, 2010 4:11 PM
  • unfortunately, the class the contains the function is an internal class. have you tried having the provisioning spit out the SQL script so you can manipulate it and then simply apply the script yourself rather than Sync Fx?
    • Proposed as answer by Ganeshan Thursday, December 9, 2010 5:50 PM
    Tuesday, December 7, 2010 11:13 PM
  • yeah... we can do that. But it would be nice to have the custom  provider with set of classes similar to SQL Server provider if possible.

    Wednesday, December 8, 2010 1:29 AM