archive-dk.com » DK » N » NDESOFT.DK

Total: 240

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Database design on user defined properties
    have as many properties as we want per media and document and we can quite simple add other types such as Users BUT When we have this setup we must rely heavily on our code to help us not to have the same property on more than one media and to ensure we don t mix media properties with documents and users And if we add an other type Users we must create not only one but two new tables and still expand a complex code to handle that new type as well as the other types So how can we solve this problem We have Media Documents and more types that has dynamic properties without the other types must know about it we could do this Each type now has its own set of properties Yeah I ve also done this one And this is almost I wrote almost as bad as the other ones Well no property can be on more than one media or document or whatever and no property can be on both media and document so whats the problem Well for starters we have to tables instead of one per type If we add an other field to our properties we must add them to all of our Property tables And if we want to list all properties including the media document user whatever it is attached to it s nearly impossible So here s the solution I find most fitting for the problem Added a Node table with the shared fields from Media and Document Removed ID and Name fields from Media and Document added a NodeID field as both PK and FK Added a Property table that references the Node table So this is my solution I have added a Node table with the shared fields from Media and Document ID and Name Removed ID and Name fields from Media and Document added a NodeID field as both primary key and foreign key this field must NOT be autoincremented It will not work then I added a Property table that references the Node table The pros and cons The pros are easy One table per type each type gets its ID from the Node table all properties are stored in one table referencing the Node table so a Document can get its properties using only its primary key No property can ever be on two entities at once and no entity knows about other entities or properties except its own The cons are that we must have some code that handles the inheritance When I make a SELECT FROM Media I must make a JOIN on the Node table as well If you re a NET developer like I then you should take a look at the Entity Framework as it handles this smoothly I will write a post on that later on Posted on April 13 2013 by Nick Frederiksen in C Database Programmering Tags architecture database database architecture database structure db

    Original URL path: http://ndesoft.dk/2013/04/13/database-design-on-user-defined-properties/ (2016-04-28)
    Open archived version from archive


  • Database Archives - NDesoft
    in C Database Programmering Tags architecture database database architecture database structure db dynamic entity framework EntityFramework inheritance properties server sql SQL Server structure T SQL social news 758 http ndesoft dk 2013 04 13 database design on user defined properties Database design on user defined properties 0 Search this site Recent Posts Create magic with APE Umbraco and NET magic Real MVC App using Umbraco revisited How to create a real MVC app using umbraco Why NOT to use umbraco as a data store Recent Comments Nick Frederiksen on How to create a real MVC app using umbraco Lazau Florin on How to create a real MVC app using umbraco Nico on How to create a real MVC app using umbraco Nick Frederiksen on Real MVC App using Umbraco revisited Nick Frederiksen on Why NOT to use umbraco as a data store ASP NET MVC C CSS Database Generelt Grafik Javascript jQuery Mine systemer og gadgets NMultiselect PHP Programmering umbraco Vista Web windows XHTML Archives Archives Select Month June 2014 1 March 2014 1 August 2013 1 May 2013 2 April 2013 2 January 2013 1 December 2011 1 July 2011 3 May 2011 3 April 2011 1 March 2011

    Original URL path: http://ndesoft.dk/category/programmering/database-programmering/ (2016-04-28)
    Open archived version from archive

  • architecture Archives - NDesoft
    in C Database Programmering Tags architecture database database architecture database structure db dynamic entity framework EntityFramework inheritance properties server sql SQL Server structure T SQL social news 758 http ndesoft dk 2013 04 13 database design on user defined properties Database design on user defined properties 0 Search this site Recent Posts Create magic with APE Umbraco and NET magic Real MVC App using Umbraco revisited How to create a real MVC app using umbraco Why NOT to use umbraco as a data store Recent Comments Nick Frederiksen on How to create a real MVC app using umbraco Lazau Florin on How to create a real MVC app using umbraco Nico on How to create a real MVC app using umbraco Nick Frederiksen on Real MVC App using Umbraco revisited Nick Frederiksen on Why NOT to use umbraco as a data store ASP NET MVC C CSS Database Generelt Grafik Javascript jQuery Mine systemer og gadgets NMultiselect PHP Programmering umbraco Vista Web windows XHTML Archives Archives Select Month June 2014 1 March 2014 1 August 2013 1 May 2013 2 April 2013 2 January 2013 1 December 2011 1 July 2011 3 May 2011 3 April 2011 1 March 2011

    Original URL path: http://ndesoft.dk/tag/architecture/ (2016-04-28)
    Open archived version from archive

  • database architecture Archives - NDesoft
    Frederiksen in C Database Programmering Tags architecture database database architecture database structure db dynamic entity framework EntityFramework inheritance properties server sql SQL Server structure T SQL social news 758 http ndesoft dk 2013 04 13 database design on user defined properties Database design on user defined properties 0 Search this site Recent Posts Create magic with APE Umbraco and NET magic Real MVC App using Umbraco revisited How to create a real MVC app using umbraco Why NOT to use umbraco as a data store Recent Comments Nick Frederiksen on How to create a real MVC app using umbraco Lazau Florin on How to create a real MVC app using umbraco Nico on How to create a real MVC app using umbraco Nick Frederiksen on Real MVC App using Umbraco revisited Nick Frederiksen on Why NOT to use umbraco as a data store ASP NET MVC C CSS Database Generelt Grafik Javascript jQuery Mine systemer og gadgets NMultiselect PHP Programmering umbraco Vista Web windows XHTML Archives Archives Select Month June 2014 1 March 2014 1 August 2013 1 May 2013 2 April 2013 2 January 2013 1 December 2011 1 July 2011 3 May 2011 3 April 2011 1 March

    Original URL path: http://ndesoft.dk/tag/database-architecture/ (2016-04-28)
    Open archived version from archive

  • database structure Archives - NDesoft
    Frederiksen in C Database Programmering Tags architecture database database architecture database structure db dynamic entity framework EntityFramework inheritance properties server sql SQL Server structure T SQL social news 758 http ndesoft dk 2013 04 13 database design on user defined properties Database design on user defined properties 0 Search this site Recent Posts Create magic with APE Umbraco and NET magic Real MVC App using Umbraco revisited How to create a real MVC app using umbraco Why NOT to use umbraco as a data store Recent Comments Nick Frederiksen on How to create a real MVC app using umbraco Lazau Florin on How to create a real MVC app using umbraco Nico on How to create a real MVC app using umbraco Nick Frederiksen on Real MVC App using Umbraco revisited Nick Frederiksen on Why NOT to use umbraco as a data store ASP NET MVC C CSS Database Generelt Grafik Javascript jQuery Mine systemer og gadgets NMultiselect PHP Programmering umbraco Vista Web windows XHTML Archives Archives Select Month June 2014 1 March 2014 1 August 2013 1 May 2013 2 April 2013 2 January 2013 1 December 2011 1 July 2011 3 May 2011 3 April 2011 1 March

    Original URL path: http://ndesoft.dk/tag/database-structure/ (2016-04-28)
    Open archived version from archive

  • db Archives - NDesoft
    XML DBManager Så er min XML Manager til NMapperen ved at være godt moden Jeg bruger den på mit arbejde sammen med NMapperen selvfølgelig og har i den forbindelse fundet en hel del svagheder i den I den seneste version er de fleste af de svagheder blevet helbredt Et af mine problemer opstod da jeg ville indsætte Posted on August 28 2009 by Nick Frederiksen in C Programmering Tags NET NET 3 5 cache datamapper db db manager manager NMapper xml social news 481 http ndesoft dk 2009 08 28 xml dbmanager XML DBManager 0 Search this site Recent Posts Create magic with APE Umbraco and NET magic Real MVC App using Umbraco revisited How to create a real MVC app using umbraco Why NOT to use umbraco as a data store Recent Comments Nick Frederiksen on How to create a real MVC app using umbraco Lazau Florin on How to create a real MVC app using umbraco Nico on How to create a real MVC app using umbraco Nick Frederiksen on Real MVC App using Umbraco revisited Nick Frederiksen on Why NOT to use umbraco as a data store ASP NET MVC C CSS Database Generelt Grafik Javascript jQuery

    Original URL path: http://ndesoft.dk/tag/db/ (2016-04-28)
    Open archived version from archive

  • dynamic Archives - NDesoft
    in C Database Programmering Tags architecture database database architecture database structure db dynamic entity framework EntityFramework inheritance properties server sql SQL Server structure T SQL social news 758 http ndesoft dk 2013 04 13 database design on user defined properties Database design on user defined properties 0 Search this site Recent Posts Create magic with APE Umbraco and NET magic Real MVC App using Umbraco revisited How to create a real MVC app using umbraco Why NOT to use umbraco as a data store Recent Comments Nick Frederiksen on How to create a real MVC app using umbraco Lazau Florin on How to create a real MVC app using umbraco Nico on How to create a real MVC app using umbraco Nick Frederiksen on Real MVC App using Umbraco revisited Nick Frederiksen on Why NOT to use umbraco as a data store ASP NET MVC C CSS Database Generelt Grafik Javascript jQuery Mine systemer og gadgets NMultiselect PHP Programmering umbraco Vista Web windows XHTML Archives Archives Select Month June 2014 1 March 2014 1 August 2013 1 May 2013 2 April 2013 2 January 2013 1 December 2011 1 July 2011 3 May 2011 3 April 2011 1 March 2011

    Original URL path: http://ndesoft.dk/tag/dynamic/ (2016-04-28)
    Open archived version from archive

  • entity framework Archives - NDesoft
    Frederiksen in C Database Programmering Tags architecture database database architecture database structure db dynamic entity framework EntityFramework inheritance properties server sql SQL Server structure T SQL social news 758 http ndesoft dk 2013 04 13 database design on user defined properties Database design on user defined properties 0 Search this site Recent Posts Create magic with APE Umbraco and NET magic Real MVC App using Umbraco revisited How to create a real MVC app using umbraco Why NOT to use umbraco as a data store Recent Comments Nick Frederiksen on How to create a real MVC app using umbraco Lazau Florin on How to create a real MVC app using umbraco Nico on How to create a real MVC app using umbraco Nick Frederiksen on Real MVC App using Umbraco revisited Nick Frederiksen on Why NOT to use umbraco as a data store ASP NET MVC C CSS Database Generelt Grafik Javascript jQuery Mine systemer og gadgets NMultiselect PHP Programmering umbraco Vista Web windows XHTML Archives Archives Select Month June 2014 1 March 2014 1 August 2013 1 May 2013 2 April 2013 2 January 2013 1 December 2011 1 July 2011 3 May 2011 3 April 2011 1 March

    Original URL path: http://ndesoft.dk/tag/entity-framework/ (2016-04-28)
    Open archived version from archive