Home > SQL Server, SQLAzure > SQL Hints

SQL Hints


CodeFluent Entities allows developers to specify SQL specific hints on its methods.

For instance, doing as so:

<cf:project xmlns:cf=“http://www.softfluent.com/codefluent/2005/1″
            xmlns:cfps=“http://www.softfluent.com/codefluent/producers.sqlserver/2005/1″>

 <Customer>
    <Id />
    <Name />
    <cf:method name=“LoadByName”
            body=“load(string name) Where Name=@name” cfps:tableHint=“NOLOCK“ />
 </Customer>
</cf:project>

Will generate a T-SQL stored procedure with the NOLOCK hint applied to the Customer table.

A recurring question that we have is “which SQL Server hints does CodeFluent support?“. Well the answer is very straightforward: all of them! Since, the applied hint isn’t inferred from the specified value, it means that regarding CodeFluent, you could specify anything! All that matters is that the specified hint is actually supported by the targeted platform.

For an exhaustive hint list, please check-out your SQL Server’s corresponding documentation:

CodeFluent Entities R&D Team

  1. No comments yet.
  1. February 1, 2011 at 8:36 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s