Hello Is there a way so that LLBL doesnt query like this

select * FROM database.dbo.table

and do this instead

select * FROM dbo.table directly

i think having the database name could be a problem in performance always , plus makes the size of the text sent from the application to the SQL server bigger also , imagine query with 5 tables and we always use the database name , now imagine 10000 queries per minute ,thats a great deal of text .

Any help is appreciated .

Hi Amr,

Quoting the Manual (ref...):

You can rename the same schema for different databases to different names. You can also specify an empty string. In that case, the schema name isn't generated into the SQL. For some situations this can be handy, though keep in mind that if you use empty strings for schemas on SqlServer, you also have to specify an empty string for the catalog name in a catalog name overwrite section.

An example:

<configSections>
       <section name="sqlServerSchemaNameOverwrites" type="System.Configuration.NameValueSectionHandler" />
       <section name="sqlServerCatalogNameOverwrites" type="System.Configuration.NameValueSectionHandler" />
</configSections>

<appSettings>
       <add key="Main.ConnectionString" value="data source=.;initial catalog=Northwind;integrated security=SSPI;persist security info=False;packet size=4096"/> 
</appSettings>

<sqlServerSchemaNameOverwrites>
       <add key="dbo" value="" />
</sqlServerSchemaNameOverwrites>

<sqlServerCatalogNameOverwrites>
       <add key="Northwind" value="" />
</sqlServerCatalogNameOverwrites>