CODEWITHSUNDEEP
.netamazon-web-servicesamazon-dynamodb
Pramod Gehlot
Pramod Gehlot

Reputation: 349

Get data from two table in dynamo db

I am using dynamo db(no sql) in .net

I have two table is bellowing

  1. Item (itemid , itemname)
  2. Category (categoryid , categoryname, itemid)

so there i want to access { itemid ,itemname,categoryid,categoryname)

and how i create table structure .

Please help me.

Upvotes: 1

Views: 2909

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 270164

Amazon DynamoDB is a NoSQL (non-relational) database, which means it is not possible to "join" tables together.

If you wish to combine information from these two tables (eg via itemid), you would need to retrieve data separately from each table and combine the information within your application.

You can create indexes on tables (eg the Category table might have an index on itemid) that would make it easier to retrieve specific data.

Upvotes: 6

Related Questions