C#

public static List<PartModel> QueryInventoryParts(List<<SearchItemModel>> SearchTerms, int ProducId = 0)
{
    using (SparesDataContext context = getDataContext())
    {
        List<<PartModel>> retVal = new List<<PartModel>>();

        foreach (SearchItemModel searchModel in SearchTerms)
        { 
            List<<PartModel>> results = (from pp in context.mmlProductsParts
                                        join pa in context.tblParts on pp.PartId equals pa.PartId
                                        where pa.PartNumber.Contains(searchModel.SearchTerm) ||
                                                pa.Keyword.Contains(searchModel.SearchTerm)
                                        select new PartModel
                                        {
                                            PartId = pa.PartId,
                                            Category = GetCategory(pa.CategoryId),
                                            PartNumber = pa.PartNumber,
                                            Keywords = pa.Keyword,
                                            PartDescription = pa.Description,
                                            Price = pa.Price.Value,
                                            Ratio = pa.Ratio.Value,
                                            Tribal = pa.Tribal
                                        }).ToList();

            foreach (var result in results)
            {
                retVal.Add(result);
            }
        }
        return retVal;
    }
}

var temp = (from pr in context.tblProducts
                join pp in context.mmlProductsParts on pr.ProductId equals pp.ProductId
                join pa in context.tblParts on pp.PartId equals pa.PartId
                where pr.ProductSeries.Contains(searchModel.SearchTerm) ||
                        pr.ProductNumber.Contains(searchModel.SearchTerm)
                select new ProductModel
                {
                    ProductId = pr.ProductId,
                    ProductNumber = pr.ProductNumber,
                    ProductSeries = pr.ProductSeries,
                    Parts = (new PartModel
                            {
                                PartId = pa.PartId,
                                Category = GetCategory(pa.CategoryId),
                                PartNumber = pa.PartNumber,
                                Keywords = pa.Keyword,
                                PartDescription = pa.Description,
                                Price = pa.Price.Value,
                                Ratio = pa.Ratio.Value,
                                Tribal = pa.Tribal
                            }).ToList())
                }).ToList();

using (DataSet data = DataGateway.getAbsence(TripNum)) 
{ 
  data.DataSetName = "Absence"; 
  data.Tables[0].TableName = "Employee"; 
  XmlDataDocument xmldoc = new XmlDataDocument(Data); 
  XslTransform xslt = new XslTransform; 
  string xsltfile = "myfile.xsl"; 
  xslt.Load(xsltfile); 
  TextWriter writer = new StringWriter(); 
  xslt.Transform(xmldoc, null, writer, null); 
  MailMessage mail = new MailMessage(); 
  mail.Body = writer.ToString(); 
  mail.From = "me"; 
  mail.To = "you"; 
  //more code to send mail...... 
}

UDPClient 

UDPClient 

    // This constructor arbitrarily assigns the local port number.
    UdpClient udpClient = new UdpClient("224.0.1.1", 3333);
    try
    {
  //      udpClient.Connect("224.0.1.1", 3333);

        // Sends a message to the host to which you have connected.

        MemoryStream ms = new MemoryStream();
        BinaryWriter bw = new BinaryWriter(ms);

        Int32 b = 0x01;
        bw.Write(b); //MsgOpCode = 0x01
        string str = "FF:FF:FF:FF:FF:FF";
        bw.Write(Encoding.ASCII.GetBytes(str.ToCharArray()));//mac
        bw.Write('\0');//-ip
        bw.Write('\0');//-mask

        byte[] byteArray = ms.GetBuffer();

        udpClient.Send(byteArray, byteArray.Length);

        // Sends a message to a different host using optional hostname and port parameters.

        //IPEndPoint object will allow us to read datagrams sent from any source.
        IPEndPoint RemoteIpEndPoint = new IPEndPoint(IPAddress.Any, 0);

        // Blocks until a message returns on this socket from a remote host.
        Byte[] receiveBytes = udpClient.Receive(ref RemoteIpEndPoint);
        string returnData = Encoding.ASCII.GetString(receiveBytes);

        // Uses the IPEndPoint object to determine which of these two hosts responded.
        Console.WriteLine("This is the message you received " +
                                     returnData.ToString());
        Console.WriteLine("This message was sent from " +
                                    RemoteIpEndPoint.Address.ToString() +
                                    " on their port number " +
                                    RemoteIpEndPoint.Port.ToString());

        udpClient.Close();
    }
    catch (Exception e)
    {
        Console.WriteLine(e.ToString());
    }
}

************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'TO'.
Incorrect syntax near the keyword 'TO'.
Incorrect syntax near '0'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at AgentBase.Business.clsDataModel.fncCreateNewDatabase(String DBNAME, String FILELOCATION) in C:\AgentBase.2010\AgentBase.Business\clsDataModel.cs:line 91
   at AgentBase.Gui.usxConnections.butCreateDB_Click(Object sender, EventArgs e) in C:\AgentBase.2010\AgentBase.Gui\usxConnections.cs:line 293
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

using System;
using System.IO;
using System.Data.SqlClient;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AgentBase.Datalayer;
public static void fncCreateNewDatabase(string DBNAME, string FILELOCATION )
		{
		
			SqlConnection myConn = new SqlConnection(Globals.ConnectionString);		  

			string str = "CREATE DATABASE " + DBNAME + " ON PRIMARY " +
				"(NAME = " + DBNAME + "_Data, " +
				"FILENAME = '" + FILELOCATION + "\\DATA\\" + DBNAME + "_Data.mdf', " +
				"SIZE = 10MB, MAXSIZE = 10000MB, FILEGROWTH = 10%) " +
				"LOG ON (NAME = " + DBNAME + "_Log, " +
				"FILENAME = '" + FILELOCATION + "\\DATA\\" + DBNAME + "_Log.ldf', " +
				"SIZE = 5MB, " +
				"MAXSIZE = 50000MB, " +
				"FILEGROWTH = 10%)";

            string myServer = myConn.DataSource.ToString();

            SqlCommand myCommand = new SqlCommand(str, myConn);
			myConn.Open();
			myCommand.ExecuteNonQuery();
           
            myConn.Close();
            myConn = new SqlConnection("Server=" + myServer + ";Integrated security=SSPI;database=" + DBNAME + "");
            myConn.Open();
            SqlCommand cmd = new SqlCommand();
            //SqlDataReader reader;
            string sourceDir = "C:\\AgentBase.2010\\AgentBase\\bin\\Debug\\database\\";
            string[] fileEntries = Directory.GetFiles(sourceDir);
            foreach (string fileName in fileEntries)
            {

                // do something with fileName
                //FileInfo file = new FileInfo("C:\\AgentBase.2010\\AgentBase\\bin\\Debug\\database\\CreateDBStructure.sql");
                FileInfo file = new FileInfo(fileName.ToString());
                string script = file.OpenText().ReadToEnd();

                cmd.CommandText = script;
                //cmd.CommandType = System.Data.CommandType.Text;            //cmd.CommandType = cmd.CommandType.Text;
                cmd.Connection = myConn;
                cmd.ExecuteNonQuery();
			
            }
"

IF exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sptblPersonGetAll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
   PRINT 'Dropping procedure sptblPersonGetAll ...'
   DROP PROCEDURE [dbo].[sptblPersonGetAll]
END
GO
PRINT 'Creating procedure sptblPersonGetAll ...'
GO


CREATE PROCEDURE [dbo].[sptblPersonGetAll]
(@PE_ID int
,@PE_RE_ID bigint
,@PE_TYPE bigint
,@PE_LASTNAME nvarchar(50)
,@PE_FIRSTNAME nvarchar(50)
,@PE_INITIALS nvarchar(50)
,@PE_CONFIRMATIONS bit
,@PE_INVOICES bit
,@PE_NEWORDER bit
)
AS
/* *********************************************************************************
**   Database:    REZON4V9
**   Project:     REZON4V9
**
**   Name:        [sptblPersonGetAll]
**   Decription:  Gets all the records in the '[tblPerson]' that match
**                the specified critieria. 
**
**   Remarks:     Any parameters passed as NULL will not affect the records returned.
**                They will effectively be ignored in the WHERE clause.
**
**   Called From: daltblPerson 
**
************************************************************************************
**                     CHANGE HISTORY
**  Change No:   Date:          Author:   Description:
**  _________    ___________    ______    ______________________________________
**     001       2/4/2011     V        Created.                                
**
** ****************************************************************************** */

SET NOCOUNT ON
SET XACT_ABORT OFF -- Allow procedure to continue after error

DECLARE @ProcName    varchar(30)       -- Name of this procedure
DECLARE @Error       integer           -- Local variable to capture the error code.
DECLARE @RowCnt      integer           -- Number of rows returned 
DECLARE @ErrMsg      nvarchar(1000)    -- Error message to return
DECLARE @Parameters  nvarchar(4000)    -- String representing parameters



-- *******************
-- Set local variables
-- *******************
SELECT @ProcName  = object_name(@@procid)
     , @Error     = 0
     , @RowCnt    = 0



-- *****************************************
-- Parameter string. Used for error handling
-- *****************************************
SET @Parameters = '' 
                + ' PE_ID:' + COALESCE(CONVERT(VARCHAR, @PE_ID), 'NULL')
                + ' PE_RE_ID:' + COALESCE(CONVERT(VARCHAR, @PE_RE_ID), 'NULL')
                + ' PE_TYPE:' + COALESCE(CONVERT(VARCHAR, @PE_TYPE), 'NULL')
                + ' PE_LASTNAME:' + COALESCE(CONVERT(VARCHAR, @PE_LASTNAME), 'NULL')
                + ' PE_FIRSTNAME:' + COALESCE(CONVERT(VARCHAR, @PE_FIRSTNAME), 'NULL')
                + ' PE_INITIALS:' + COALESCE(CONVERT(VARCHAR, @PE_INITIALS), 'NULL')
                + ' PE_CONFIRMATIONS:' + COALESCE(CONVERT(VARCHAR, @PE_CONFIRMATIONS), 'NULL')
                + ' PE_INVOICES:' + COALESCE(CONVERT(VARCHAR, @PE_INVOICES), 'NULL')
                + ' PE_NEWORDER:' + COALESCE(CONVERT(VARCHAR, @PE_NEWORDER), 'NULL')



-- ************
-- Get the data
-- ************
SELECT [PE_ID]
      ,[PE_RE_ID]
      ,[PE_TYPE]
      ,[PE_LASTNAME]
      ,[PE_FIRSTNAME]
      ,[PE_INITIALS]
      ,[PE_SEX]
      ,[PE_FUNCTION]
      ,[PE_PHONE]
      ,[PE_FAX]
      ,[PE_MOBILE]
      ,[PE_WEBSITE]
      ,[PE_EMAIL]
      ,[PE_SKYPE]
      ,[PE_LINKEDIN]
      ,[PE_FACEBOOK]
      ,[PE_BIRTHDAY]
      ,[PE_MEMO]
      ,[IS_DATECREATED]
      ,[IS_WHO]
      ,[IS_DATECHANGED]
      ,[PE_CONFIRMATIONS]
      ,[PE_INVOICES]
      ,[PE_NEWORDER]
      ,[PE_CONTACTFOR]
      ,[PE_SPEAKSLANGUAGE]
  FROM [dbo].[tblPerson]
 WHERE (([PE_ID] = @PE_ID) OR (@PE_ID IS NULL))
   AND (([PE_RE_ID] = @PE_RE_ID) OR (@PE_RE_ID IS NULL))
   AND (([PE_TYPE] = @PE_TYPE) OR (@PE_TYPE IS NULL))
   AND (([PE_LASTNAME] LIKE @PE_LASTNAME + '%') OR (@PE_LASTNAME IS NULL))
   AND (([PE_FIRSTNAME] = @PE_FIRSTNAME) OR (@PE_FIRSTNAME IS NULL))
   AND (([PE_INITIALS] = @PE_INITIALS) OR (@PE_INITIALS IS NULL))
   AND (([PE_CONFIRMATIONS] = @PE_CONFIRMATIONS) OR (@PE_CONFIRMATIONS IS NULL))
   AND (([PE_INVOICES] = @PE_INVOICES) OR (@PE_INVOICES IS NULL))
   AND (([PE_NEWORDER] = @PE_NEWORDER) OR (@PE_NEWORDER IS NULL))

SELECT @Error  = @@Error
     , @RowCnt = @@RowCount 
IF (@Error != 0)
BEGIN
   SELECT @ErrMsg = 'Error getting records. Parameters' + @Parameters
   GOTO ENDERROR
END



-- **************
-- Error Handling
-- **************
GOTO ENDOK

ENDERROR:
   BEGIN
      EXEC spErrorLogInsert 'DB Layer', @ProcName, @Error, @ErrMsg
      RAISERROR 25000 @ErrMsg
      RETURN 1
   END

ENDOK:
   RETURN 0
GO



IF ( object_id('dbo.sptblPersonGetAll') IS NOT NULL )
BEGIN
   PRINT 'Success: Created procedure sptblPersonGetAll.'
END
IF ( object_id('dbo.sptblPersonGetAll') IS NULL )
BEGIN
   PRINT 'ERROR: sptblPersonGetAll was not created successfully.'
END
GO