NPoco create and open connection

NPoco create and open connection

  1. using (SqlConnection connection = new SqlConnection(conString))
                using (IDatabase db = new Database(connection))
                {
                    connection.Open();
                    // Do DB Operation here
                }
Use this snippet to properly create an open a connection using NPoco.
NOTE: constring is the connection string
    • Related Articles

    • SharePoint Adobe Sign - Send Document

      1. Create MergeFields Dictionary of all fields to populate in the form 2. Bools/Checkboxes should be set to a workflow string of YES or NO 3. Each Type in the MergeFields should be a string, no numbers 4. Find the document id from the "Send" link on ...
    • SharePoint Adobe Sign - Download document

      1. Set a workflow variable to OUT_FOR_SIGNATURE 2. Create a loop while a workflow AgreementStatus variable is OUT_FOR_SIGNATURE 3. Use Adobe Sign Action "Get Agreement status for Agreement ID" 3a. Use Agreement ID from the current item saved in the ...
    • Adding files (attachments) to the Send Mail API in Zoho Deluge

      files = opportunity.getJSON("File_1"); if(files != null) { for each file in files { fileMap = Map(); fileId = file.getJSON("File_Id__s"); fileMap.put("id",fileId); attachmentsList.add(fileMap); } } emailDataMap.put("attachments",attachmentsList); ...