LLBLGEN v4.2 with SQL Server 2016

Posts   
 
    
VicB
User
Posts: 2
Joined: 05-Dec-2016
# Posted on: 05-Dec-2016 07:32:04   

Hi,

We currently have SQL Server 2008 R2 and LLBLGen v4.2. My company is now planning to upgrade straight to SQL Server 2016. I have been looking on google but couldn't find anything concrete. Will LLBLGen v4.2 work with SQL Server 2016? If no, does that mean we will have to go straight to LLBLGen v5.0 or above? Are there significant breaking changes in this upgrade or minimal? Please let me know.

Thanks

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 05-Dec-2016 08:59:59   

it will work fine with 2016, though specific 2016 features aren't available of course, those are implemented in v5 (e.g. temporal tables). Always encrypted is supported as that's a connectionstring directive.

Frans Bouma | Lead developer LLBLGen Pro
VicB
User
Posts: 2
Joined: 05-Dec-2016
# Posted on: 05-Dec-2016 09:41:26   

but when i try to connect it with sql server 2016, i don't see the database drivers there. it shows them like this:

SQL Server 2000/2005/2008/2008R2/2012/Express Driver (SqlClient).

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 05-Dec-2016 12:01:16   

VicB wrote:

but when i try to connect it with sql server 2016, i don't see the database drivers there. it shows them like this:

SQL Server 2000/2005/2008/2008R2/2012/Express Driver (SqlClient).

yes, because you use a release that's released before 2016 was RTM so it doesn't contain the name of a future sqlserver db included wink But there's fallback code in place which will make sure you can connect to any future sql server version (unless they change the metadata tables etc.) it just doesn't use sql server 2016 specific features Just 2014 features and lower.

Frans Bouma | Lead developer LLBLGen Pro