LLBL 4.5 EF6 - Collation?

Posts   
 
    
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 18-Feb-2015 20:17:01   

I use LLBL 4.5 with EF6 on SQL Server 2014.

Is there a way in a query to set the collation? Our database is set to a standard Latin collation, but some of the data is in other languages, like Icelandic.

How can I tell the Linq Query to use a different collation?

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 19-Feb-2015 04:44:32   

Seems to be a pure EF6 question.

The following thread suggests a couple of solutions including one specific for LLBLGen Framework. http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12216

I'd say that if the database fields have the correct collation, then you are good to go, and you may use the CaseSensetive flag when comparing text in these fields.