How can I insert persian number in SQL with entity framework?

Question

0.00/5 (No votes)

See more:

hi ,i want to insert manually into sqlserver 2014
db : booking , table : reserved(reservedId,RoomId,UserId,Start_date,End_date)
my dbs collation is : persian_100_ci_ai
when i insert persian date it will save like : ????/??/??
but in english like : 1395/04/02
what should i do?

C#

public static RESERVED insert_res(int room_id, string s_date, string e_date)
{
    RESERVED a;
    using(bookingEntities db = new bookingEntities())
    {
        a = new RESERVED();
        a.ROOMID = room_id;
        a.USERID = 3;
        a.START_DATE = s_date;
        a.END_DATE = e_date;
        db.RESERVEDs.Add(a);
        db.SaveChanges();
    }
    return a;
}

What I have tried:

i dont know what should i do to fix this problem!

Posted 13-Jul-16 21:09pm

saeed rajabi

Updated 17-May-17 19:08pm

v4

Add a Solution

Comments

[no name] 14-Jul-16 3:11am

Have a look here: Persian Date/Time support for MsSQL - Home[^]

saeed rajabi 14-Jul-16 4:20am

now i want insert with entity framework

i update my question please look again!

[no name] 14-Jul-16 5:40am

Maybe this helps and please take into account, the only things I recognized where the Screen shots :)
.NET Tips - افزودن یک DataType جدید برای نگه‌داری تاریخ خورشیدی - 1[^]

Richard Deeming 14-Jul-16 10:02am

Simple - do not store dates as strings. Use date as the SQL data type, and DateTime as the C# data type.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Answer 1 · 2016-07-14T05:13:00

Guessing that Persian numbers are not arabian numbers.
what you get is a string of symbols that are the Persian number symbols.
Either you use them as is and store them as strings, but you can't do any calculus with them.
Either you translate the Persian symbols to Arabian numbers, so that you can then convert them to numbers ( int or float) or dates. Then you can do with them all what you do with ints or floats.

I fear you have to build a couple functions to convert Persian symbols to Arabian once and reverse.

Computer languages only handle numeric values via Arabian numbers.
It will probably be easier to find functions that do the trick between Arabian numbers and Roman numbers. The principle should be close enough to be used as a model.

Hamid Reza Adeli · Answer 2 · 2017-05-17T19:08:00

Solution 2

check this post :

insert farsi data to sql data base[^]

Posted 17-May-17 19:08pm

Hamid Reza Adeli