database localization - lookup lists - smarter way

i'm looking supplement lookup lists database, nonetheless i wish easy localizable (sql 2005, ado.net)

this include:

• easy supervision churned languages during same time


• easy retrieval values database


• fallback libel (in box comparison libel missing)

i pondering carrying list store multi-language lookup-list (using opposite languages same id) duty relapse value look-up list - receiving id language.

one pitfalls i have manually supplement libel parameter each query uses lookup list.

i'm looking fortitude let me send parameter "session/global variable", send parameter automatically sql query, duty collect itself (either insert parameter automatically, presumably means review parameter).

the fortitude feeling something this, nonetheless i don't mind different, enlarged doesn't give parameter definitely query (pseudocode):

1. send libel controlling "the method"
2. govern query
3. localized results

clarification:

1. normally query feeling (remember controlling lookup function):

   
   
   

   select .., getlookuplist1(lookup_id, language), .. table

the getlookuplist1 user tangible duty retrieves lookup value lookup table. controlling function, sql formula easier review maintain.

the physique duty something like:

select @result = lookupvalue lookuptable1 where id=@lookup_id language=@lang
return @result

2. what i wish means mislay libel parameter duty kind stationary variable, accessible wholly tide connection/statement/command, query feeling like

   
   
   

   select .., getlookuplist1(lookup_id), .. table