Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Database with dynamically created columns in C# with MongoDB

 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am new to the world of non-relational database and I look for some advices on how to start.

I need to have table that represents system being optimized. It should have some columns with input data (some of those are common for all systems and some are specific for the system so I know all the columns I need to use not earlier than when I need to create first row in database) and output data (columns are always the same).

I need to be able to visualize the data being stored, i.e. dynamically search for rows where input parameters are known (for example first column is equal to abc and second column is between 15 and 20) to be able to receive corresponding output values (several last columns).

I thought about using MongoDB because it has the best support and is the most widely used non-relational database. Please enlight me if it is good choise or I need other NoMQL (which one?).

I have started with creating some simple code:



this is why I started wondering if it is good to use MongoDB or if I do something incorrectly. Definitely adding row as "first entity" is not OK because I would need something like ID here. And using foreach later is perhaps not needed at all, based on earlier lines of the code.

Class with data looks as follows:



Could you give me any suggestions how I should proceed with my case?

Best regards!

PS In order to avoid hidden crossposting - this post can be found at "Database with dynamically created columns in C#" in google group https://groups.google.com/forum/#!topic/mongodb-user/8Uw7YlLq0K4
 
Whatever. Here's a tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
    Bookmark Topic Watch Topic
  • New Topic