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, render software, radio reference, online coding software, o * net online, html 5 pattern, how to produce an app, foundation software, features of html 5, small bar, small architecture, render architecture, product render, OX, implement, c small coding project, architecture render, statement structure sql, name software project event, div screen, coding implement, radio event, small web app, php cart app, change bit

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

ID do Projeto: #3024043