Is there any query in Entity Framework so i can convert first letter of each record in uppercase
ex:
India
China
Australia
England
Japan

Question

Is there any query in Entity Framework so i can convert first letter of each record in uppercase ex: India China Australia England Japan

Vulpes · Answer

I'd see if it will accept it if you convert to a local query: TextInfo ti = CultureInfo.GetCultureInfo("en-Us").TextInfo; var query1 = from bookinformation in ent.BOOKINFORMATIONs .AsEnumerable() select ti.ToTitleCase(bookinformation.AUTHORNAME.ToLower()); query1 = query1.Distinct(); cmb1.DataSource = query1; cmb1.DataBind();

nallya · Answer

Thank you Vulpes it works great.

nallya · Answer

Giving Exception: LINQ to Entities does not recognize the method 'System.String ToTitleCase(System.String)' method, and this method cannot be translated into a store expression. And my query is TextInfo ti = CultureInfo.GetCultureInfo("en-Us").TextInfo; var query1 = from bookinformation in ent.BOOKINFORMATIONs select ti.ToTitleCase(bookinformation.AUTHORNAME.ToLower()); query1 = query1.Distinct(); cmb1.DataSource = query1; cmb1.DataBind();

Vulpes · Answer

Just looked back to your previous thread to get an idea of what you might be doing. Try this: using System.Globalization; //.... TextInfo ti = CultureInfo.GetCultureInfo("en-Us").TextInfo; // say var query1 = from bookinformation in ent.BOOKINFORMATIONs select ti.ToTitleCase(bookinformation.COUNTRY.ToLower());

Is there any query in Entity Framework so i can convert first letter of each record in uppercase

Answers (4)