LEADTOOLS WCF (Leadtools.Services.DataContracts assembly) Send comments on this topic. | Back to Introduction - All Topics | Help Version 17.0.3.30
DbBinaryData Class
See Also  Members  
Leadtools.Services.DataContracts Namespace : DbBinaryData Class



The DbBinaryData Class is available in LEADTOOLS Document and Medical Imaging toolkits.

Loads and saves files to and from a database.

Object Model

DbBinaryData ClassDbBinaryDataParameterDictionary ClassObject Class

Syntax

Visual Basic (Declaration) 
<DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")>
Public Class DbBinaryData 
   Inherits BinaryData
Visual Basic (Usage)Copy Code
Dim instance As DbBinaryData
C# 
[DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")]
public class DbBinaryData : BinaryData 
C++/CLI 
[DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")]
public ref class DbBinaryData : public BinaryData 

Example

This example will convert a TIF file in a source folder to a CMP file and save it into a database field.

Visual BasicCopy Code
Public Sub DbBinaryDataExample()
      Dim client As RasterServiceClient = New RasterServiceClient()
      Dim sourceBinaryData As FileBinaryData = New FileBinaryData()
      sourceBinaryData.FileName = Path.Combine(LEAD_VARS.ImagesDir, "clean.tif")

      Dim destinationBinaryData As DbBinaryData = New DbBinaryData()
      destinationBinaryData.Provider = DbBinaryDataProvider.SqlServer
      destinationBinaryData.CommandType = DbBinaryDataCommandType.Text
      destinationBinaryData.CommandText = "insert into ImagesTable (Image) values (@Image);"
      destinationBinaryData.ConnectionString = "server=sp2007ep;" & "Trusted_Connection=yes;" & "database=Images;" & "connection timeout=30"
      destinationBinaryData.Parameters = New DbBinaryDataParameter()
      destinationBinaryData.Parameters.Add("Image", Nothing)
      destinationBinaryData.DataFieldType = DbBinaryDataFieldType.Raw
      destinationBinaryData.DataFieldName = "Image"

      Dim convertOptions As RasterConvertOptions = New RasterConvertOptions()

      convertOptions.Source = sourceBinaryData
      convertOptions.Destination = destinationBinaryData
      convertOptions.Format = RasterImageFormat.Cmp
      convertOptions.FirstPage = 1
      convertOptions.LastPage = 1
      convertOptions.BitsPerPixel = 24
      convertOptions.QualityFactor = 2

      Dim request As ConvertRequest = New ConvertRequest()
      request.ConvertOptions = convertOptions

      client.Convert(request)

      client.Close()
   End Sub

Public NotInheritable Class LEAD_VARS
   Public Const ImagesDir As String = "C:\Users\Public\Documents\LEADTOOLS Images"
End Class
C#Copy Code
public void DbBinaryDataExample()
   {
      RasterServiceClient client = new RasterServiceClient();
      FileBinaryData sourceBinaryData = new FileBinaryData();
      sourceBinaryData.FileName = Path.Combine(LEAD_VARS.ImagesDir,"clean.tif");

      DbBinaryData destinationBinaryData = new DbBinaryData();
      destinationBinaryData.Provider = DbBinaryDataProvider.SqlServer;
      destinationBinaryData.CommandType = DbBinaryDataCommandType.Text;
      destinationBinaryData.CommandText = "insert into ImagesTable (Image) values (@Image);";
      destinationBinaryData.ConnectionString = "server=sp2007ep;" + "Trusted_Connection=yes;" + "database=Images;" + "connection timeout=30";
      destinationBinaryData.Parameters = new DbBinaryDataParameter();
      destinationBinaryData.Parameters.Add("Image", null);
      destinationBinaryData.DataFieldType = DbBinaryDataFieldType.Raw;
      destinationBinaryData.DataFieldName = "Image";

      RasterConvertOptions convertOptions = new RasterConvertOptions();

      convertOptions.Source = sourceBinaryData;
      convertOptions.Destination = destinationBinaryData;
      convertOptions.Format = RasterImageFormat.Cmp;
      convertOptions.FirstPage = 1;
      convertOptions.LastPage = 1;
      convertOptions.BitsPerPixel = 24;
      convertOptions.QualityFactor = 2;

      ConvertRequest request = new ConvertRequest();
      request.ConvertOptions = convertOptions;

      client.Convert(request);

      client.Close();
   }

static class LEAD_VARS
{
   public const string ImagesDir = @"C:\Users\Public\Documents\LEADTOOLS Images";
}

Remarks

Calls the LoadData and SaveData methods internally to load and save data to and from a database field specified by UrlBinaryData.Url.

Inheritance Hierarchy

System.Object
   Leadtools.Services.DataContracts.BinaryData
      Leadtools.Services.DataContracts.DbBinaryData

Requirements

Target Platforms: Microsoft .NET Framework 3.0, Windows 2000, Windows XP, Windows Server 2003 family, Windows Server 2008 family, Windows Vista, Windows 7

See Also

Applications developed with LEADTOOLS WCF components require runtime licenses. Server licensing is required for applications on a server. For more information, refer to: Imaging Pro/Document/Medical Features