Data coming in column name alphabetical order. How to resolve it?

nallya

I am having table payroll_employee in which having(id,firstname,lastname,contact,email,address) these fields,but when i tried to retrieve data it comes in order(address,contact,email,firstname,id,lastname) i.e.in alphabetical order how to solve it
using oracle.
plz help ,
thank you.

2 Replies

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

nallya14y ago
my code is like
public List Select_Employee()
        {
            var query = from payroll_employee in ent.PAYROLL_EMPLOYEE select payroll_employee;
                        //select new
                        //{
                        //    EmpID=payroll_employee.EMPID,
                        //    FirstName=payroll_employee.FIRSTNAME,
                        //    LastName=payroll_employee.LASTNAME,
                        //    ContactNo=payroll_employee.CONTACTNO,
                        //    Email=payroll_employee.EMAIL,
                        //    Address=payroll_employee.ADDRESS

                        //};
            List list = new List();
            list = query.ToList();
            return list;
        }

IF I WRITE IN THE WAY U SAYING IT GIVES ERROR(CASTING)
I AM USING WCF SERVICE WITH ENTITY FRAMEWORK AND ORACLE DATABASE
Sukesh Marla14y ago
Use column Names explicity in Select query instead of *
as
Select id,firstname,lastname,contact,email,address From payroll_employee
Check this is correct answer if it helped