Bean Software Search Control Documentation   
 
 
     




SQLSyntax Property


Description:
Represents a SQL syntax of database technology used in your application. With MS SQL, MySQL and Oracle databases you can use full text search or syntax with LIKE keyword. MS Access supports searching with LIKE keyword only. Standard ANSI SQL syntax is also supported.

[Visual Basic .NET]

Public Property SQLSyntax() As enuSQLSyntax


[C#]

public enuSQLSyntax SQLSyntax() {get; set;}

Data type: enuSQLSyntax

Default value: enuSQLSyntax.ANSIStandardSQL

Example: For some small starting web site you decided that is enough to use MS Access database. After few months, database become too large for MS Access. Also, web site si now very popular and number of visits demand a lot of database connections. You need to switch to some more powerfull database technology, like MySQL, MS SQL or Oracle. Whatever you decide, you don't need to write a new code for your web application! It is enough only to change SQLSyntax property to the appropriate value. You can even quickly test your web application with different database technologies to see what is the best solution.