Loads entities of type EntityType using a custom SQL parameterized Query.

Namespace:  Aspectize.Core
Assembly:  AspectizeDAL (in AspectizeDAL.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

C#
List<EntityType> GetEntitiesFromSQL<EntityType>(
	string sql,
	params Object[] parameters
)
where EntityType : new(), Entity
Visual Basic (Declaration)
Function GetEntitiesFromSQL(Of EntityType As {New, Entity}) ( _
	sql As String, _
	ParamArray parameters As Object() _
) As List(Of EntityType)

Parameters

sql
Type: System..::.String
The custom SQL parameterized Query string.
parameters
Type: array< System..::.Object >[]()[]
The array of parameters to be passed to the command. Parameter names are built by appending a column name to '@'.

Type Parameters

EntityType
Type of Entity to load

Return Value

List of EntityType loaded by the queries

Remarks

Custom query string references physical names.

Examples

CopyC#
string sqlClause = "SELECT * FROM Production.Product where Name Like @Name Or Color = @Color";

List<AdventureWorks.Production.Product> products = dm.GetEntitiesFromSQL<AdventureWorks.Production.Product>(sqlClause, "C%", "Black" );
CopyVB.NET
Dim sqlClause As String = "SELECT * FROM Production.Product where Name Like @Name Or Color = @Color"

Dim products As List(Of AdventureWorks.Production.Product) = dm.GetEntitiesFromSQL(Of AdventureWorks.Production.Product)(sqlClause, "C%", "Black")

See Also