Using DLinq as SQL builder

[Andrus]

I need to pass DLinq query to RDLDEsigner.
RDLDesigner does not accept IQueryable<T>.
It accepts SQL select statement in plain text format as data source.

How to get SELECT statement which corresponds to dlinq query
as plain text as it is being sent to server ?

How to create method which allows to grab the sql statement which is being
passed to DataReader without executing DataReader and opening connection.

Something like

Northwind.Customers.Select().GetCommandText()


Andrus.

 

[Marc Gravell]

For LINQ-to-SQL, GetCommand() on the data-context.

Marc

 

[Andrus]

Marc,

For LINQ-to-SQL, GetCommand() on the data-context.

Thank you.
I havent found any information how it handles parameters and don't have MS
SQL installed.

Will it return parameters replaced with values or show placeholders instead
of parameter values ?

Andrus.

 

[Marc Gravell]

placeholders; for example:

C#:

string s = "abc";
var qry = ctx.Customers
.Where(x => x.Address == s)
.OrderBy(x => ctx.Random());

TSQL (note @p0):

SELECT [t0].[CustomerID], [t0].[CompanyName], [t0].[ContactName],
[t0].[ContactT
itle], [t0].[Address], [t0].[City], [t0].[Region], [t0].[PostalCode],
[t0].[Coun
try], [t0].[Phone], [t0].[Fax]
FROM [dbo].[Customers] AS [t0]
WHERE [t0].[Address] = @p0
ORDER BY NEWID()

Marc