Generic Data Link Layer

 This Data Link Layer returns Objects of the Classes. I tried to give a generic look so tht it can be used in any project. It will require small changes.


using System;
using System.Data;
//using System.Configuration;
using System.Linq;
//using System.Web;
//using System.Xml.Linq;
using System.Data.SqlClient;
using McAfee.Utilities.DatabaseHelper;
using System.Collections.Generic;

namespace Blog.BO
{
    ///

    /// Summary description for Database_Connection
    ///

    public class Database_Connection
    {
        private string sql_Connection_String = new ConnectionString().GetConnectionString();
        public List
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Class Logic



public UserObject Forobject(SqlDataReader reader, List names)//(string name, object val)
        {
            UserObject new_User = new UserObject();
            foreach (string name in names)
            {
                switch (name)
                {
                    case "userId": new_User.UserId = (string)reader[name];
                        break;
                    case "username": new_User.UserName = (string)reader[name];
                        break;
                }
            }
            return new_User;
        }
              
      
    //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Class

 public class UserObject
    {
        public string UserName { get; set; }
        public string UserId { get; set; }
        public string Password { get; set; }
    

    } 
   

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Example which uses this:

public List GetData()
        {
            int input_Size = 10;
            SqlParameter[] sql_Param= null;
            List

XML Readers use

Checking the efficency by 3 readers.
1.XMl Document
2.Xml Reader
3.XPath Naviagtor


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Xml;
using System.Xml.XPath;
using System.Diagnostics;
using System.IO;

namespace EffeciencyCheckInXMLReadOperations
{
    public partial class Form1 : Form
    {
        string m_fileName = @"DataFile.xml";
        string m_XPath = "configuration/appSettings";
        string m_Path = "appSettings";
        string m_File_string;
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            m_File_string = File.ReadAllText(m_fileName);
        }

        private IEnumerable ReadXML(XmlReader reader)
        {
            Member member = null;
            if (!reader.ReadToFollowing(m_Path))
                yield return member;

            while (reader.Read() && reader.NodeType != XmlNodeType.EndElement)
            {
                if (!reader.HasAttributes)
                    continue;
                member = new Member();
                member.Data = reader.GetAttribute("key", "");
                member.Value = reader.GetAttribute("value", "");
                yield return member;
            }
        }   
       

        private IEnumerable ReadXML(XPathNavigator xPathNav)
        {
            Member member = null;
            xPathNav = xPathNav.SelectSingleNode(m_XPath);
            if (xPathNav == null)
                yield return member;
           
            xPathNav.MoveToFirstChild();
                do
                {
                    if (!xPathNav.HasAttributes)
                        continue;
                    member = new Member();
                    member.Data = xPathNav.GetAttribute("key", "");
                    member.Value = xPathNav.GetAttribute("value", "");
                    yield return member;
                } while (xPathNav.MoveToNext());
           
        }
        private IEnumerable ReadXML(XmlDocument xmlDoc)
        {
            xmlDoc.LoadXml(m_File_string);
            Member member = null;
            XmlNode node = xmlDoc.SelectSingleNode(m_XPath);
            if (node == null)
                yield return member;
            foreach (XmlNode child in node.ChildNodes)
            {
                if (child.NodeType == XmlNodeType.Comment)
                    continue;
                member = new Member();
                member.Data = child.Attributes[0].Value;
                member.Value = child.Attributes[1].Value;
                yield return member;
            }
        }

        private void XMLReader_Click(object sender, EventArgs e)
        {

            DateTime startWatch = DateTime.Now;
            StringReader rdr = new StringReader(m_File_string);
            using (XmlReader reader = XmlReader.Create(rdr))
            {
                dataGridView1.DataSource = ReadXML(reader).ToList();
            }
            DateTime stopWatch = DateTime.Now;
            TimeSpan time = stopWatch - startWatch;
            MessageBox.Show(time.ToString());
        }

        private void XPathDocument_Click(object sender, EventArgs e)
        {
            DateTime startWatch = DateTime.Now;
            StringReader rdr = new StringReader(m_File_string);
            dataGridView1.DataSource = ReadXML(new XPathDocument(rdr).CreateNavigator()).ToList();
            DateTime stopWatch = DateTime.Now;
            TimeSpan time = stopWatch - startWatch;
            MessageBox.Show(time.ToString());
        }

        private void XMLDocument_Click(object sender, EventArgs e)
        {
            DateTime startWatch = DateTime.Now;
            dataGridView1.DataSource = ReadXML(new XmlDocument()).ToList();
            DateTime stopWatch = DateTime.Now;
            TimeSpan time = stopWatch - startWatch;
            MessageBox.Show(time.ToString());
        }
       
    }       

       
   

    class Member
    {
        public string Data { get; set; }
        public string Value { get; set; }
    }


}



XML file:

How To Use Streams in C#

 Chk this out. If possible Give me a better solution.


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO.Compression;
using System.IO;

namespace StreamTesting
{
    class Program
    {
        static void Main(string[] args)
        {
            string inputFile= "c:/u.log.gz";
            Console.WriteLine("Enter File Path");
           // inputFile=Console.ReadLine();
            FileInfo file = new FileInfo(inputFile);
            if (file.Exists)
            {
                Decompress(file);
            }
        }

        public static void Decompress(FileInfo file)
        {
            using (FileStream fs = new FileStream(file.FullName, FileMode.Open, FileAccess.Read))
            {
                if (file.Extension == ".gz")
                {
                    Display(new GZipStream(fs, CompressionMode.Decompress, false));
                }
                else
                    Display(fs);

            }
        }

        static void Display(Stream stream)
        {
            Console.WriteLine("Enter No. of lines wanted to Display");
            try
            {
                int n = Int32.Parse(Console.ReadLine());
                int count = -4;
                foreach (string line in ReadFile(stream))
                {
                    if (!line.Contains("#") || count < 0)
                    {
                        Console.WriteLine(line);
                        Console.ReadKey();
                        count++;

                    }
                    if (count == n)
                        break;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("Enter numbers");
            }
 
        }

        static IEnumerable ReadFile(Stream stream)
        {
            using (StreamReader reader = new StreamReader(stream))
            {
                string line=null;
                while ((line = reader.ReadLine()) != null)
                {
                    yield return line;
                }
            }
        }

    }
}





In this program I am using Gzip stream to printout line by line of the file. Here I learned how to use stream.