How can i fectch whole table data into array using edmx or linq to sql classes

Question

0.00/5 (No votes)

See more:

Hi ,
i want to below code into edmx or linq same thing using guide me or send snippets, the data should be return in json format ,for that i am using in wcf service

C#

public Employee[] GetAllEmployee()
        {
            List<employee> lstEmp = new List<employee>();
            SqlConnection Conn = new SqlConnection("Data Source=.\\sezpress;Initial Catalog=Test;User ID=sa;Password=bhss");
            Conn.Open();
            SqlCommand Cmd = new SqlCommand("Select * from Employee", Conn);
            SqlDataReader Reader = Cmd.ExecuteReader();
            while (Reader.Read())
            {
                lstEmp.Add(new Employee()
                {
                    EmpNo = Convert.ToInt32(Reader["EmpNo"]),
                    EmpName = Reader["EmpName"].ToString(),
                    DeptNo = Convert.ToInt32(Reader["DeptNo"]),
                    Salary = Convert.ToInt32(Reader["Salary"])
                });
            }
            Reader.Close();

            Conn.Close();

            return lstEmp.ToArray();
        }

Posted 21-Oct-13 19:01pm

kingsa

Updated 21-Oct-13 20:14pm

CodeBlack

v3

Add a Solution

Comments

CodeBlack 22-Oct-13 2:14am

what you have tried and error you are getting ?

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)

Ranjan.D · Answer 1 · 2013-10-22T16:40:00

Solution 2

Have a look into the below mentioned article to learn how to create a EF based solution.

Using the Entity Framework 4.3 in .NET Development[^]

Posted 22-Oct-13 16:40pm

Ranjan.D

Nhilesh B · Answer 2 · 2013-10-22T16:33:00

Hi,

I am not sure, if you want to use C# but this is much simple with the DLL, I use ["Newtonsoft.Json.dll"] found at http://json.codeplex.com/[^].

There are two methods available i.e Serialize and Deserialize data-table

C#

public static string Serialize(object value)
       {
           if (value != null)
           {
               Type type = value.GetType();

               JsonSerializer json = new JsonSerializer();

               json.NullValueHandling = NullValueHandling.Ignore;

               json.ObjectCreationHandling = ObjectCreationHandling.Replace;
               json.MissingMemberHandling = MissingMemberHandling.Ignore;
               json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;

               //if (type == typeof(DataRow))
               //    json.Converters.Add(new DataRowConverter());
               //else
               if (type == typeof(DataTable))
                   json.Converters.Add(new DataTableConverter());
               else if (type == typeof(DataSet))
                   json.Converters.Add(new DataSetConverter());

               StringWriter sw = new StringWriter();
               JsonTextWriter writer = new JsonTextWriter(sw);
               //if (this.FormatJsonOutput)
               //    writer.Formatting = Formatting.Indented;
               //else
               writer.Formatting = Formatting.None;

               writer.QuoteChar = '"';
               json.Serialize(writer, value);

               string output = sw.ToString();
               writer.Close();
               sw.Close();

               return output;
           }
           else
           {
               return "{no data found}";
           }
       }

       public static object Deserialize(string jsonText, Type valueType)
       {
           JsonSerializer json = new JsonSerializer();

           json.NullValueHandling = NullValueHandling.Ignore;
           json.ObjectCreationHandling = ObjectCreationHandling.Replace;
           json.MissingMemberHandling = MissingMemberHandling.Ignore;
           json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;

           StringReader sr = new StringReader(jsonText);
           JsonTextReader reader = new JsonTextReader(sr);
           object result = json.Deserialize(reader, valueType);
           reader.Close();

           return result;
       }

Hope this helps.

Regards,
NBaua