oracle - What data type to use for some number, date and phone number in c#? -


Hi, hi, I have an application in asp.net, which includes four text fields for number, amount, date and telephone.

When a button is clicked, these values ​​should be saved in the Oracle database. Processes used to save these values ​​are in the Oracle database datatypes, the number is the column type type, the amount is the column type number, the date is the date time of the column type and the phone number is the number of the number. I am using assumptions for all four text areas so that these values ​​are in the proper format. In my code I am passing the number of times, date, telephone as string and quantity in quantity. Is this the best thing? If anyone can not give me the recommendation of the data type to use for 4 types (number, amount, date and telephone number)?

If this works, then this is a "good" practice. You are not doing this one hundred times in the loop, so efficiency is not an issue. What you are doing is clear and understandable and is a good fit for the type of data you handle. The date and phone number format are difficult to edit. Do you have to deal with international dates (most of the world is fond of DD-MM-Y) and non-US phone numbers? I like your data types

Comments