Sql.Net Class Library Documentation

SelectQuery.TableSpace Property

Gets or sets the common prefix for all tables in the query

public string TableSpace {get; set;}


You might want to use TableSpace property to utilize SQL Server 2000 execution plan cache. For the cache to work in SQL Server 2000, all database objects in a query must be fully qualified. Setting TableSpace property might releive of the duty to fully qualify all table names in the query.

See Also

SelectQuery Class | Reeb.SqlOM Namespace