ASP MVC名单电子商务产品与动态变化的指标 [英] asp mvc list ecommerce product with dynamically changing specifications
问题描述
我试图开发产品的详细信息页面,电子商务网站,说我们列出了一些产品中的观点,现在当一个产品,他是采取产品的详细信息用户点击视图来显示产品规格,加入购物车,评论等,但这里的产品规格是动态变化的每一个产品,例如:
i am trying to develop product details page for eCommerce site, say we list some products in a view , now when users clicks in a product he is taken product details view to show product specifications, with add to cart, reviews etc , but here product specification changes dynamically for every product , example:
服装产品:
尺寸
40
移动产品:
操作系统
:Android的
现在我不想在服装产品的规范名称的操作系统,反之亦然。
now i dont want the specification name operating system in a clothing product and vice versa.
所以我研究这个,发现<一个href=\"http://dba.stackexchange.com/questions/62271/database-design-for-ecommerce-website-with-multiple-products-having-huge-specifi\">this和这个职位的。但是,<一个href=\"http://stackoverflow.com/questions/870808/entity-attribute-value-database-vs-strict-relational-model-ecommerce-question\">some民间的评论说实体属性值不是好的做法
,
so i researched about this and found this and this post's . But some folk's comment saying Entity Attribute Value is not good practice
,
所以任何人都可以帮我选最好的,易于设计模式列出产品的细节与ASP MVC改变规格,我是新来的这一点。
so can anyone help me choose best and easy design pattern to list product details with changing specifications in asp mvc, i am new to this.
任何帮助将是巨大的。
Any help would be great.
推荐答案
EAV有几个缺点:
- 数据库层不能强迫属性名称是正确的,所以你必须做,在code
- 搜索性能很慢,如果你的价值观在EAV表过滤
- 性能也慢,如果你尝试基于EAV表 的值加入其他表
- The database layer can't force attribute names to be correct, so you have to do it in code
- Search performance is slow if you're filtering on values in the EAV table
- Performance is also slow if you try to join other tables based on the values in the EAV table
但是如果你需要一个灵活,动态的属性集您不需要寻找或属性值加盟,EAV是一个很好的解决方案。
But if you need a flexible and dynamic set of attributes and you don't need to search or join by the attribute values, EAV is a good solution.
这篇关于ASP MVC名单电子商务产品与动态变化的指标的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!