C#

var doc = new Document();
// add lucene fields mapped to db fields
doc.Add(new Field("ID", oData.ID.ToString() , Field.Store.YES, Field.Index.NOT_ANALYZED));
doc.Add(new Field("Title", oData.Title, Field.Store.YES, Field.Index.ANALYZED));
doc.Add(new Field("Description", oData.Description, Field.Store.YES, Field.Index.ANALYZED));
doc.Add(new Field("Url", oData.Url, Field.Store.YES, Field.Index.ANALYZED));
// add entry to index
writer.AddDocument(doc);

string attempt;
attempt = My_Dialogs.InputBox("Enter your password"); while (attempt != "basic")
{
MessageBox.Show("Wrong! - try again.");
attempt = InputBox("Enter your password"); }
MessageBox.Show("Welcome to the program!");

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.Net.Mail;
using System.Net;


namespace Mail_Send
{
    public partial class Form4 : Form
    {
        SmtpClient obj_SMTPClient;
        MailMessage Obj_MailMsg;
        Attachment obj_Attachment;
        //string pBar;
       
        
        public Form4()

        {
            InitializeComponent();            
        }
        
        private void Form4_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog open = new OpenFileDialog();
            if (open.ShowDialog() == DialogResult.OK)
            {
                label3.Text = open.FileName;
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void SendMail_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
            {
                MessageBox.Show("please fill, don't let a column blank!!!");
            }
            else
                try
                {
                    obj_SMTPClient = new SmtpClient("smtp.gmail.com");
                    Obj_MailMsg = new MailMessage();
                    obj_Attachment = new System.Net.Mail.Attachment(label3.Text);
                    Obj_MailMsg.From = new MailAddress(textBox1.Text);
                    Obj_MailMsg.To.Add(textBox3.Text);
                    Obj_MailMsg.Body = textBox5.Text;
                    Obj_MailMsg.Attachments.Add(obj_Attachment);
                    Obj_MailMsg.Subject = textBox4.Text;
                    SmtpClient smtps = new SmtpClient("smtp.gmail.com", 587);
                    obj_SMTPClient.Credentials = new NetworkCredential();
                    obj_SMTPClient.Port = 587;
                    obj_SMTPClient.Credentials = new System.Net.NetworkCredential(textBox1.Text, textBox2.Text);
                    obj_SMTPClient.EnableSsl = true;
                    obj_SMTPClient.Send(Obj_MailMsg);

                    obj_SMTPClient.EnableSsl = true;
                    obj_SMTPClient.Send(Obj_MailMsg);
                    MessageBox.Show("Message Successful sent!!!");
                }
                catch
                {
                    MessageBox.Show("Sorry, Request TimeOut!!!");
                }
        } 

        private void button4_Click(object sender, EventArgs e)
        {
                
        }     
     
         
    

        private void button8_Click(object sender, EventArgs e)
        {
            foreach (Control sayre in this.Controls)
            {
                if (sayre is TextBox)
                {
                    (sayre as TextBox).Clear();
                }
            } 
        }

        private void button6_Click(object sender, EventArgs e)
        {
           
        }

        private void button5_Click(object sender, EventArgs e)
        {
           
        }

        private void button4_Click_1(object sender, EventArgs e)
        {
            foreach (Control sayre in this.Controls)
            {
                if (sayre is TextBox)
                {
                    (sayre as TextBox).Clear();
                }
            }  
        }       
        
        
        }
    }  

<FunctionImport Name="GetAllBlogsAndPosts"> 
  <ReturnType EntitySet="Blogs" Type="Collection(BlogModel.Blog)" /> 
  <ReturnType EntitySet="Posts" Type="Collection(BlogModel.Post)" /> 
</FunctionImport>

using (var db = new MyEntities())
            {
                using (IDbConnection oaConnection = db.Database.Connection)
                {
                    // 3. Create a new instance of the OACommand class.
                    using (IDbCommand oaCommand = oaConnection.CreateCommand())
                    {
                        // 4. Set the CommandType property.
                        oaCommand.CommandType = CommandType.StoredProcedure;

                        // 5. Set the CommandText property.
                        oaCommand.CommandText = "gsp_get_emp_details";
                        oaCommand.Parameters.Add(empInput.EmployeeId);
                        oaCommand.Parameters.Add(empInput.UserId);
                        oaCommand.Parameters.Add(empInput.RoleList);

                        // 6. Execute the command and materialize the car entities
                        using (IDataReader dataReader = oaCommand.ExecuteReader())
                        {
                            EmployeeData empData = db.Translate<EmployeeData>(dataReader as DbDataReader);
}
}
}
}

using System.Data.Objects;