Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Andrew McDonald 8 posts 31 karma points
    Jun 11, 2017 @ 13:42
    Andrew McDonald
    0

    Throws Invalid column name 'ID' error if the id column not being named Id

    Help & Support
    Umbraco 7

    I'm trying to use UI-O-Matic with an external Sql Server database

    Unfortunately the primary key for the table I'm accessing is named something other than 'Id' and thus throws an error

    I can't change the name in the table as the people who use the database have lots of code depending on me not changing the db structure

    I'm on version 2.0.3 of UI-O-Matic, so am stumped what's causing this ????

    Anyone else come across this and fixed it ?????

    Copy Link
  • Andrew McDonald 8 posts 31 karma points
    Jun 11, 2017 @ 13:55
    Andrew McDonald
    3

    Fixed it myself

    If anyone start working external databases add the following into the code using UI-O-Matic

    [Umbraco.Core.Persistence.PrimaryKey("PrimaryKeyName")]

    • Just change 'PrimaryKeyName' to your actual PrimaryKeyName and bingo it works

    Hope this stops someone else scratching their head ;)

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft