Class SqlBlobStorageProvider
For using binary search need create manually create unique index and assign fullTextCatalog
Inherited Members
Namespace: Mediachase.BusinessFoundation.Blob
Assembly: Mediachase.BusinessFoundation.dll
Version: 10.8.0Syntax
public class SqlBlobStorageProvider : BlobStorageProviderConstructors
SqlBlobStorageProvider()
Declaration
public SqlBlobStorageProvider()Properties
ExpirationTime
Gets or sets the expiration time.
Declaration
public int ExpirationTime { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 | The expiration time. |
Remarks
in minutes.
TableName
Gets or sets the name of the table.
Declaration
public string TableName { get; set; }Property Value
| Type | Description |
|---|---|
| System.String | The name of the table. |
Methods
CleanUp(Object)
Cleans the up.
Declaration
public void CleanUp(object state)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | state | The state. |
CreateStream(BlobInfo)
Creates the stream.
Declaration
public override Stream CreateStream(BlobInfo blobInfo)Parameters
| Type | Name | Description |
|---|---|---|
| BlobInfo | blobInfo | The BLOB information. |
Returns
| Type | Description |
|---|---|
| System.IO.Stream |
Overrides
GetBlobInfoCommand(Guid, String)
Gets the BLOB info command.
Declaration
protected virtual string GetBlobInfoCommand(Guid uidStream, string pmKey)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The GUID of the stream. |
| System.String | pmKey | The pm key. |
Returns
| Type | Description |
|---|---|
| System.String |
GetInfo(Guid)
Gets the info.
Declaration
public override BlobInfo GetInfo(Guid uidStream)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The uid stream. |
Returns
| Type | Description |
|---|---|
| BlobInfo |
Overrides
GetInsertBlobInfoCommand(Guid, String)
Gets the insert BLOB info command.
Declaration
protected virtual string GetInsertBlobInfoCommand(Guid uidStream, string pmKey)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The uid stream. |
| System.String | pmKey | The pm key. |
Returns
| Type | Description |
|---|---|
| System.String |
GetSearchByContentCommand(String)
Declaration
protected virtual string GetSearchByContentCommand(string keyword)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | keyword |
Returns
| Type | Description |
|---|---|
| System.String |
GetSearchByFileNameCommand(String)
Declaration
protected virtual string GetSearchByFileNameCommand(string keyword)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | keyword |
Returns
| Type | Description |
|---|---|
| System.String |
GetUpdateBlobInfoCommand(Guid, String)
Gets the update BLOB info command.
Declaration
protected virtual string GetUpdateBlobInfoCommand(Guid uidStream, string pmKey)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The uid stream. |
| System.String | pmKey | The pm key. |
Returns
| Type | Description |
|---|---|
| System.String |
Initialize(String, NameValueCollection)
Declaration
public override void Initialize(string name, NameValueCollection config)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | name | |
| System.Collections.Specialized.NameValueCollection | config |
Overrides
ReadStream(BlobInfo)
Reads the stream.
Declaration
public override Stream ReadStream(BlobInfo blobInfo)Parameters
| Type | Name | Description |
|---|---|---|
| BlobInfo | blobInfo | The BLOB information. |
Returns
| Type | Description |
|---|---|
| System.IO.Stream |
Overrides
ReleaseBlobInfo(Guid)
Releases the BLOB info.
Declaration
protected virtual void ReleaseBlobInfo(Guid uidStream)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The uid stream. |
ReleaseBlobInfoCommand(Guid, String)
Releases the BLOB info command.
Declaration
protected virtual string ReleaseBlobInfoCommand(Guid uidStream, string pmKey)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The uid stream. |
| System.String | pmKey | The pm key. |
Returns
| Type | Description |
|---|---|
| System.String |
ReleaseStream(Guid)
Releases the stream.
Declaration
public override void ReleaseStream(Guid uidStream)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The uid stream. |
Overrides
RetrieveBlobInfo(Guid)
Retrieves the BLOB info.
Declaration
protected virtual BlobInfo RetrieveBlobInfo(Guid uidStream)Parameters
| Type | Name | Description |
|---|---|---|
| System.Guid | uidStream | The uid stream. |
Returns
| Type | Description |
|---|---|
| BlobInfo |
Search(String)
Declaration
public override BlobInfo[] Search(string keyword)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | keyword |
Returns
| Type | Description |
|---|---|
| BlobInfo[] |
Overrides
StoreBlobInfo(BlobInfo, Boolean)
Stores the BLOB info.
Declaration
protected virtual void StoreBlobInfo(BlobInfo blobInfo, bool InsertUpdate)Parameters
| Type | Name | Description |
|---|---|---|
| BlobInfo | blobInfo | The BLOB info. |
| System.Boolean | InsertUpdate | if set to |
StreamCommited(BlobInfo, BlobInfo)
Commits the stream.
Declaration
public override void StreamCommited(BlobInfo newBlobInfo, BlobInfo oldBlobInfo)Parameters
| Type | Name | Description |
|---|---|---|
| BlobInfo | newBlobInfo | The new BLOB info. |
| BlobInfo | oldBlobInfo | The old BLOB info. |
