Message Boards Message Boards

2
|
370 Views
|
2 Replies
|
4 Total Likes
View groups...
Share
Share this post:

DatabaseReference Microsoft SQLExpress Schema Other Than dbo

Test is the name of the table.

POSTED BY: Glen K. Halley
2 Replies

If I change the SQL Schema to 'dbo' and replicate the tutorial/RelationalDatabasesQuickStart, the command (Circuit is the SQL table and Id and CircuitName are the fields):

EntityValue["Circuit", {"Id", "CircuitName"}, "Dataset"]

results with the 1st column (key?) as

{Key[Entity["Circuit", 1]]}

is there a way to get ("Id" is the SQL Primary Key)

{Key[1]}

in the first column instead? Put a different way, what is the reason for the Entity in the key? The Dataset Planets example does not have the Entity.

POSTED BY: Glen K. Halley

Nice work Glen! It helps me a lot:)

POSTED BY: Zhenzhao Tu
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract