Using DLinq as SQL builder

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Andrus

    Using DLinq as SQL builder

    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.Custo mers.Select().G etCommandText()


    Andrus.

  • Marc Gravell

    #2
    Re: Using DLinq as SQL builder

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

    Marc

    Comment

    • Andrus

      #3
      Re: Using DLinq as SQL builder

      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.

      Comment

      Working...