Convert bigint to int for all keys in SLK 1.8

Topics: Developer Forum, User Forum
Aug 4, 2015 at 9:29 PM
Hi!

I am looking to use SLK 1.8 as part of our SharePoint 2010 installation.

I am also looking to use Business Connectivity Services (BCS) to access some of the SLK tables via External Lists and SPD workflows to integrate the SLK to our current systems.

I have run into an issues where it appears the "BigInt" fields from SQLServer are not available as part of the SharePoint Business Connectivity Services (BCS).

I am looking for help to figure out all of the places within the source code that I need to update to convert the keys and other fields of the tables from a type of "BigInt" to "Int".

The quantity of items that we will have will allow us to use the "Int" fields as we will NOT exceed the 2,147,483,647 limit.

I tried updating the schema only and the SLK 1.8 system failed.

Any help would be appreciated.
Aug 6, 2015 at 2:18 AM
I figured it out.
I created views in the database that CAST the bigint columns to int columns and then connected the BCS external content type to each view.

Maybe this will help others!!
Coordinator
Aug 31, 2015 at 9:10 PM
That was a good idea.

Richard