Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> LLBLGen Pro 2.6 with SQL Server 2016
 

Pages: 1 2
Designer
LLBLGen Pro 2.6 with SQL Server 2016
Page:2/2 

  Print all messages in this thread  
Poster Message
Vivek30
User



Location:

Joined on:
30-Jun-2016 15:22:47
Posted:
33 posts
# Posted on: 10-Jul-2019 09:21:06.  
Otis, we will be migrating from 2.6 to the latest ones, and we are in a process of finding the costs etc to do so.

Since this is a big jump from 2.6 to 5.2, we are assuming there will be a few roadblocks and the migration work may take some time and I would not want any regular business as usual work to get impacted, hence I'm requesting you to help me out with modifying the drivers etc for 2.6 to work with sql server 2016. This is just going to be an interim solution till the time we are completely on the latest 5.x version.
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37645 posts
# Posted on: 10-Jul-2019 10:04:26.  
The sourcecode archive, available from the v2.6 'extras' section, contains the 'drivers' solution.
Open the .sln in visual studio and remove all projects except the SQL Server driver project.
In that project you'll find a couple of .cs files. It has a SqlServerDBDriver, SqlServerCatalogRetriever and a SqlServerSchemaRetriever, among other files. These 3 are the ones you have to make some changes to. In v2.6 it uses in some methods a switch/case statement that selects a query based on the version of the database. It makes the wrong selection if the version is too high, so you have to adjust these switch statements to make sure it selects the 2008 query.

To compile the dll, remove the strong key reference (as that's not included) from the assemblyinfo.cs file and add a custom one yourself. This should make you be able to connect to newer sql server versions.


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Vivek30
User



Location:

Joined on:
30-Jun-2016 15:22:47
Posted:
33 posts
# Posted on: 10-Jul-2019 11:09:45.  
Can't find any code archives, can you rather give me the link which I can just click and get the code?
Thanks
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37645 posts
# Posted on: 10-Jul-2019 11:30:03.  
My Account -> Downloads -> v2.6 -> Extras -> LLBLGen Pro SDK.
The file contains all sourcecode we ship for the system.

I referred to source code archive, but forgot that in the v2.6 era it was bundled with the SDK Regular Smiley


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1 2  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.