locked
BCS : create an external content type and SQL alias data type RRS feed

  • Question

  • Hello,

    I'm designing a new project that has an SQL DB and external content types pointing to SQL's tables. For clarity and simplicity, I want to use alias data types as described in:

    http://technet.microsoft.com/en-us/library/ms175007.aspx

    Has anyone implemented external content type pointing to an alias data type? Are there any limitations or caveats?

    Thank you


    Christos

    Tuesday, November 19, 2013 2:06 PM

Answers

  • I don't think it should be an issue if you are creating your ECT either (1) as a .NET Assembly in Visual Studio because it can handle complex data types, OR, if you create a WCF to consume your Data OR do a OData URI to your SQL Database, both of which can return JSON data and you can use that in your ECT.

    Did you find this Helpful? Please Mark it So! Thank you.

    Connect with Me!

    Fabian G. Williams | Twitter @FabianWilliams | Blog http://www.sharepointfabian.com | Email: fabian@adotob.com

    Adotob Logo

    <

    • Marked as answer by XristosK Monday, December 2, 2013 8:56 AM
    Monday, December 2, 2013 3:29 AM