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

Question

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 ?

Sam Hobbs · Answer

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.

Dharampal Sikhwal · Answer

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.

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