Follow @Bendsoft
Documentation
Camelot .NET Connector
Latest
Intended audience
SharePoint and .NET
Installation
Visual Studio
Programming
SQL statement syntax
Procedures
Reference
Search descendants ONLY?
Table of Contents
Intended audience
SharePoint and .NET
Installation
Visual Studio
Programming
Introduction
SharePointConnection
SharePointCommand
SharePointDataAdapter
SharePointParameter
The connection string
Basic options
Performance
Security
Executing commands
Command types
Last inserted id
Last records affected
Change database
Helper class
Strings and escaping
Data types
GUID
Counter
Boolean
DateTime
Integer
Number / Currency
Text
Note
URL
Choice / MultiChoice
Lookup / LookupMulti
User / UserMulti
Calculated
Computed
Attachments
Binary
ModStat
Tutorials
ASP.NET
Download documents
NHibernate
SQL statement syntax
SHOW TABLES
SHOW COLUMNS
SHOW VIEWS
SHOW CONTENTTYPES
SELECT
INSERT
UPDATE
DELETE
JOIN
GROUP BY
UNION
CALL
USE
LAST_INSERT_ID()
Operators and functions
String functions
Date functions
Numeric functions
Aggregate functions
Procedures
CREATEFOLDER
CREATEDOCUMENTSET
UPLOAD
DOWNLOAD
DOWNLOADINFOPATH
DELETE
MOVE
COPY
RENAME
CHECKOUT
CHECKIN
UNDOCHECKOUT
GETVERSIONS
DELETEVERSION
DELETEALLVERSIONS
RESTOREVERSION
DOWNLOADATTACHMENT
UPLOADATTACHMENT
DELETEATTACHMENT
Reference
SHOW TABLES
SHOW COLUMNS
SHOW VIEWS
SHOW CONTENTTYPES
Connection String Options
Column Types