Encerrado

Implement a small bit of nHibernate entity mapping

I need a small bit of nHibernate coding to change how an existing .net project maps entities from my SQL db to my MVC3 front-end.

The db objects exist and tables are populated. I can provide SQL queries that return the correct object. The web app is already using nHibernate so the foundation of the project's structure is already implemented.

## Deliverables

Specifically, I need to implement a fairly common cross-reference pattern.

Each of the products offered by my online store have a couple different sets of Options (or 'features'). The checkout cart needs to be able to display one or another of these sets of Options.

5 tables are involved:

Products //holds product details

Options // each of the possible options that any product can posses

OptionsGroups // Each of the sets that a given product might display

OptionsGroupsXRef // maps the product to the OptionGroup

OptionsXRef // maps the Option to the OptionGroup

[see the screen cap of SQL's Diagram ]

On the front end:

I need to produce an entity for my MVC3 front-end so that this construct will render all the options associated the that specific event:

@foreach (var o in [url removed, login to view])

{

|input type="radio"

name="options"

id=@("options_" + @[url removed, login to view]) /|@:$@[url removed, login to view] -@[url removed, login to view]

|div class="hiddenDesc" style="visibility: hidden"|

@[url removed, login to view]

}

[forced to use bar character instead of html coding]

If I were working directly from SQL this statement would satisfy that need:

select [url removed, login to view]

, [url removed, login to view]

, [url removed, login to view]

, [url removed, login to view]

, [url removed, login to view]

from OptionsGroups as og

inner join OptionsGroupsXref x on [url removed, login to view] = [url removed, login to view]

inner join OptionsXref ox on [url removed, login to view] = [url removed, login to view]

inner join Options o on [url removed, login to view] = [url removed, login to view]

where [url removed, login to view] = 813

Habilidades: PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: sql coding style, radio reference, online coding software, html pattern, produce app, foundation software, small bar, small architecture, render architecture, product render, ox, implement, architecture render, statement structure sql, name software project event, div screen, coding implement, radio event, small web app, php cart app, change bit, mapping project, coding small project, diagram sql project, product display app

Acerca do Empregador:
( 0 comentários ) Holmen, United States

ID do Projeto: #3024043