How to get English text of label from database based on tab

ahmed elbarbary

7y1.2k.NET

I make project in SQL server 2012 asp.net core 2.1 visualstudio2017 and technology i using entity framework core 2.1

what I need is to get text of label control from database based on table name and field name from reference table

so that i need to make function can be used to get the label text when table fields match what exist on reference file based on table and field name .

so that How to do that ?

to more explain what i need see this example

suppose i have item table and product table

Item table have two fields

Item Code

Item Name

Product table have two fields

Product No

Product Name

reference table have 5 fields

serial	tablename	fieldname	ArabictextforLabel	EnglishtextforLabel
1	Item	ItemCode	??? ?????	ItemCodeVal
2	Item	ItemName	??? ?????	ItemNameVal
3	Product	ProductNo	??? ??????	ProductNoVal
4	Product	ProductName	??? ??????	ProductNameVal

so that when go to view Items

get text for labeles as (ItemCodeval then display itemnameval) for viewmodels for items

and same thing on product view display label text as ( productnoval and productnameval) for view model Products

and when this text for product table and items table changed this will changed on view as dynamically

this will make dynamically show text per labels

Can this available on asp.net core 2.1 entity framework core 2.1 or not and how to do it if allowed ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs7y ago
See:
Internationalization and localization - Wikipedia
https://en.wikipedia.org/wiki/Internationalization_and_localization

That probably does not help much but it gives an introduction. I think you are trying to do that; to internationalize your application. There are many articles and even books on the subject.

You want to have both an Arabic and an English name for each product, right? Well if that is all you ned to do then it whould be relatively easy to do. But if you want to support multiple languages in other ways too then it would belp to learn from others how to set it up. It will require more work now but it will probably make it easier to make improvements in the future.
+1
Dharampal Sikhwal7y ago
lf you want to get labels from database you can use below columns in table- 1. ScreenName 2. Language 3. Labelid 4. LabelText Based on ScreenName and Language fields you can get list of Labelid and LabelText for particular page. This way if you want to add support for new language, you need to add more rows in table for that language. No need to add new column in table. I hope this will help you to solve the problem.
+1