问题描述
如果一个输入被映射到数据库中的多个输出，那么如何在c＃中显示所有输出？我正致力于旁遮普语到英语音译。对于例如ਵੀਰ旁遮普语中的一个单词可以写成veer和vir，并且veer和vir都存储在数据库中，然后如何在输入中同时输出veer和vir ਵੀਰ。
我的尝试：
我我试过多个查询，但它不是一个可行的解决方案。
If one input is being mapped to more than one outputs in database ,then how to display all the outputs in c# ? I am working on punjabi to english transliteration. For e.g. "ਵੀਰ" a word in punjabi can be written as "veer" and "vir", and both "veer" and "vir" are stored in database ,then how to have both the outputs of "veer" and "vir" on input of "ਵੀਰ".
What I have tried:
I am tried with multiple queries but its not a feasible solution.
推荐答案
create table basewords
(
id int identity(1,1),
word nvarchar(125)
)
insert into basewords values ('ਵੀਰ')然后，链接回该基表的翻译单词表每个base可以有很多条目字。例如：
Then a table for the translation words that links back to that base table can have many entries per "base" word. For example:
create table translated
(
id int identity(1,1),
word nvarchar(125),
transOf int -- Foreign key back to basewords
)
insert into translated values
('veer',1),
('vir',1)然后，您可以使用以下简单查询获取匹配的单词：
Then you can get the matching words back with this simple query:
select B.word, T.word as translation
from basewords B
left outer join translated T on B.id=T.transOf哪会产生结果
word translation
ਵੀਰ veer
ਵੀਰ vir
这篇关于从数据库中检索单个属性的多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！