InterLINQ

New Post: Interlinq and Silverlight 2.0 b2

dcstraw — Mon, 18 Aug 2008 16:01:04 GMT

I am also very interested in this. In my efforts to get this to work I have been able to work around almost everything, with the exception of:
1. Return values
2. Expressions that contain object references (like member variables)

I could just have #2 be a caveat to the use of InterLinq queries, but #1 is obviously not something you can caveat. At this point it looks like the next step may be to write a custom serializer/deserializer.

Created Issue: Exception An expression of type 'System.Object' cannot be used to initialize an array of type 'System.Object[]

gherold — Mon, 21 Jul 2008 16:45:26 GMT

The class SerializableExpressionVisitor throw a TargetInvocationException with innerException message is
An expression of type 'System.Object' cannot be used to initialize an array of type 'System.Object[]
when processing the following lines :

else if( expression is SerializableLambdaExpression ) {
if( expression is SerializableExpressionTyped ) {
MethodInfo executeMethod = GetType().GetMethod( "VisitSerializableExpressionTyped", BindingFlags.NonPublic | BindingFlags.Instance );
MethodInfo genericExecuteMethod = executeMethod.MakeGenericMethod( new Type[] { (Type) expression.Type.GetClrVersion() } );
returnValue = (Expression) genericExecuteMethod.Invoke( this, new object[] { expression } ); <=== RAISE
}
else {
returnValue = VisitSerializableLambdaExpression( expression as SerializableLambdaExpression );
}
}

when expression equals : { => new [] {Convert(.Key), Convert(Count())}}

New Post: Could you can show me a sample for interlinq to vs2008 orm

wxzself — Sun, 29 Jun 2008 01:36:51 GMT

Sorry my pool english. Can you show me a simple sample for interlinq query vs2008 orm. both client and server. Thank's a lot.

New Post: Quality of generated code

RobTF — Fri, 20 Jun 2008 23:43:11 GMT

Hi guys,

Just a quick question - when passing any EF query via InterLinq it changes from something like this;

SELECT
'0X0X' AS [C1],
[Extent1].[BusinessEntityID] AS [BusinessEntityID],
[Extent2].[Name] AS [Name],
[Extent2].[CreatedDate] AS [CreatedDate],
[Extent2].[ModifiedDate] AS [ModifiedDate],
[Extent2].[Flags] AS [Flags],
[Extent1].[AccountID] AS [AccountID],
[Extent1].[Status] AS [Status]
FROM [dbo].[Order] AS [Extent1]
INNER JOIN [dbo].[BaseEntity] AS [Extent2] ON [Extent1].[BusinessEntityID] = [Extent2].[BusinessEntityID]

into the following monstrosity....

SELECT
CASE WHEN ([UnionAll3].[C12] = 1) THEN '0X0X' WHEN ([UnionAll3].[C11] = 1) THEN '0X1X' WHEN ([UnionAll3].[C13] = 1) THEN '0X2X' ELSE '0X3X' END AS [C1],
[UnionAll3].[C1] AS [C2],
[Extent2].[Name] AS [Name],
[Extent2].[CreatedDate] AS [CreatedDate],
[Extent2].[ModifiedDate] AS [ModifiedDate],
[Extent2].[Flags] AS [Flags],
CASE WHEN ([UnionAll3].[C12] = 1) THEN [UnionAll3].[C2] WHEN ([UnionAll3].[C11] = 1) THEN CAST(NULL AS decimal(19,4)) WHEN ([UnionAll3].[C13] = 1) THEN CAST(NULL AS decimal(19,4)) END AS [C3],
CASE WHEN ([UnionAll3].[C12] = 1) THEN [UnionAll3].[C3] WHEN ([UnionAll3].[C11] = 1) THEN CAST(NULL AS bit) WHEN ([UnionAll3].[C13] = 1) THEN CAST(NULL AS bit) END AS [C4],
CASE WHEN ([UnionAll3].[C12] = 1) THEN CAST(NULL AS uniqueidentifier) WHEN ([UnionAll3].[C11] = 1) THEN [UnionAll3].[C4] WHEN ([UnionAll3].[C13] = 1) THEN CAST(NULL AS uniqueidentifier) END AS [C5],
CASE WHEN ([UnionAll3].[C12] = 1) THEN CAST(NULL AS uniqueidentifier) WHEN ([UnionAll3].[C11] = 1) THEN [UnionAll3].[C5] WHEN ([UnionAll3].[C13] = 1) THEN CAST(NULL AS uniqueidentifier) END AS [C6],
CASE WHEN ([UnionAll3].[C12] = 1) THEN CAST(NULL AS int) WHEN ([UnionAll3].[C11] = 1) THEN [UnionAll3].[C6] WHEN ([UnionAll3].[C13] = 1) THEN CAST(NULL AS int) END AS [C7],
CASE WHEN ([UnionAll3].[C12] = 1) THEN CAST(NULL AS uniqueidentifier) WHEN ([UnionAll3].[C11] = 1) THEN CAST(NULL AS uniqueidentifier) WHEN ([UnionAll3].[C13] = 1) THEN [UnionAll3].[C7] END AS [C8],
CASE WHEN ([UnionAll3].[C12] = 1) THEN CAST(NULL AS int) WHEN ([UnionAll3].[C11] = 1) THEN CAST(NULL AS int) WHEN ([UnionAll3].[C13] = 1) THEN [UnionAll3].[C8] END AS [C9],
CASE WHEN ([UnionAll3].[C12] = 1) THEN CAST(NULL AS bit) WHEN ([UnionAll3].[C11] = 1) THEN CAST(NULL AS bit) WHEN ([UnionAll3].[C13] = 1) THEN CAST(NULL AS bit) ELSE [UnionAll3].[C9] END AS [C10],
CASE WHEN ([UnionAll3].[C12] = 1) THEN CAST(NULL AS decimal(19,4)) WHEN ([UnionAll3].[C11] = 1) THEN CAST(NULL AS decimal(19,4)) WHEN ([UnionAll3].[C13] = 1) THEN CAST(NULL AS decimal(19,4)) ELSE [UnionAll3].[C10] END AS [C11]
FROM   (SELECT
[UnionAll2].[C1] AS [C1],
[UnionAll2].[C2] AS [C2],
[UnionAll2].[C3] AS [C3],
[UnionAll2].[C4] AS [C4],
[UnionAll2].[C5] AS [C5],
[UnionAll2].[C6] AS [C6],
[UnionAll2].[C7] AS [C7],
[UnionAll2].[C8] AS [C8],
[UnionAll2].[C9] AS [C9],
[UnionAll2].[C10] AS [C10],
[UnionAll2].[C11] AS [C11],
[UnionAll2].[C12] AS [C12],
[UnionAll2].[C13] AS [C13]
FROM (SELECT
  [UnionAll1].[C1] AS [C1],
  [UnionAll1].[C2] AS [C2],
  [UnionAll1].[C3] AS [C3],
  [UnionAll1].[C4] AS [C4],
  [UnionAll1].[C5] AS [C5],
  [UnionAll1].[C6] AS [C6],
  [UnionAll1].[C7] AS [C7],
  [UnionAll1].[C8] AS [C8],
  [UnionAll1].[C9] AS [C9],
  [UnionAll1].[C10] AS [C10],
  [UnionAll1].[C11] AS [C11],
  [UnionAll1].[C12] AS [C12],
  [UnionAll1].[C13] AS [C13]
  FROM (SELECT
   [Project1].[C1] AS [C1],
   CAST(NULL AS decimal(18,0)) AS [C2],
   CAST(NULL AS bit) AS [C3],
   [Project1].[C2] AS [C4],
   [Project1].[C3] AS [C5],
   [Project1].[C4] AS [C6],
   CAST(NULL AS uniqueidentifier) AS [C7],
   CAST(NULL AS int) AS [C8],
   CAST(NULL AS bit) AS [C9],
   CAST(NULL AS decimal(18,0)) AS [C10],
   cast(1 as bit) AS [C11],
   cast(0 as bit) AS [C12],
   cast(0 as bit) AS [C13]
   FROM ( SELECT
    CAST(NULL AS uniqueidentifier) AS [C1],
    CAST(NULL AS uniqueidentifier) AS [C2],
    CAST(NULL AS uniqueidentifier) AS [C3],
    CAST(NULL AS int) AS [C4]
    FROM ( SELECT cast(1 as bit) AS X ) AS [SingleRowTable1]
   ) AS [Project1]
   WHERE 1 = 0
  UNION ALL
   SELECT
   [Extent1].[BusinessEntityID] AS [BusinessEntityID],
   CAST(NULL AS decimal(18,0)) AS [C1],
   CAST(NULL AS bit) AS [C2],
   CAST(NULL AS uniqueidentifier) AS [C3],
   CAST(NULL AS uniqueidentifier) AS [C4],
   CAST(NULL AS int) AS [C5],
   [Extent1].[AccountID] AS [AccountID],
   [Extent1].[Status] AS [Status],
   CAST(NULL AS bit) AS [C6],
   CAST(NULL AS decimal(18,0)) AS [C7],
   cast(0 as bit) AS [C8],
   cast(0 as bit) AS [C9],
   cast(1 as bit) AS [C10]
   FROM [dbo].[Order] AS [Extent1]) AS [UnionAll1]
UNION ALL
  SELECT
  [Project5].[C1] AS [C1],
  [Project5].[C2] AS [C2],
  [Project5].[C3] AS [C3],
  CAST(NULL AS uniqueidentifier) AS [C4],
  CAST(NULL AS uniqueidentifier) AS [C5],
  CAST(NULL AS int) AS [C6],
  CAST(NULL AS uniqueidentifier) AS [C7],
  CAST(NULL AS int) AS [C8],
  CAST(NULL AS bit) AS [C9],
  CAST(NULL AS decimal(18,0)) AS [C10],
  cast(0 as bit) AS [C11],
  cast(1 as bit) AS [C12],
  cast(0 as bit) AS [C13]
  FROM ( SELECT
   CAST(NULL AS uniqueidentifier) AS [C1],
   CAST(NULL AS decimal(19,4)) AS [C2],
   CAST(NULL AS bit) AS [C3]
   FROM ( SELECT cast(1 as bit) AS X ) AS [SingleRowTable2]
  ) AS [Project5]
  WHERE 1 = 0) AS [UnionAll2]
UNION ALL
SELECT
[Project8].[C1] AS [C1],
CAST(NULL AS decimal(18,0)) AS [C2],
CAST(NULL AS bit) AS [C3],
CAST(NULL AS uniqueidentifier) AS [C4],
CAST(NULL AS uniqueidentifier) AS [C5],
CAST(NULL AS int) AS [C6],
CAST(NULL AS uniqueidentifier) AS [C7],
CAST(NULL AS int) AS [C8],
[Project8].[C2] AS [C9],
[Project8].[C3] AS [C10],
cast(0 as bit) AS [C11],
cast(0 as bit) AS [C12],
cast(0 as bit) AS [C13]
FROM ( SELECT
  CAST(NULL AS uniqueidentifier) AS [C1],
  CAST(NULL AS bit) AS [C2],
  CAST(NULL AS decimal(19,4)) AS [C3]
  FROM ( SELECT cast(1 as bit) AS X ) AS [SingleRowTable3]
) AS [Project8]
WHERE 1 = 0) AS [UnionAll3]
INNER JOIN [dbo].[BaseEntity] AS [Extent2] ON [UnionAll3].[C1] = [Extent2].[BusinessEntityID]

Two things;

1. Any ideas why?
2. Can I prevent this?

many thanks

Rob

NEW POST: Interlinq and Silverlight 2.0 b2

mbmbeers — Mon, 09 Jun 2008 11:48:29 GMT

Hi,

Silverlight 2.0 b2 subset of the 3.5 framework does not have the NetDataContractSerializer.
Is it possible to get around that limitation?

Kind regards
Morten

COMMENTED ISSUE: SerializableExpression not serializable with DataContractSerializer

GaussZ — Thu, 05 Jun 2008 16:59:25 GMT

I tried using the SerializableExpression from LINQ to send an expression through a WCF webservice. Alas the SerializableExpression contains InterLinqType which itself contain the "public Type RepresentedType" property which is not serializable (because System.Type (i.e. RuntimeType) is not serializable) but marked with the DataMember attribute.
Is there a reason for that which I missed?

I changed the code to:
[DataMember(Name = "RepresentedType")]
private String m_representedType;

/// <summary>
/// Gets or sets the represented <see cref="Type"/>.
/// </summary>
public Type RepresentedType {
get { return Type.GetType(m_representedType); }
set { m_representedType = value.AssemblyQualifiedName; }
}

and changed all access to m_representedType to the property. That allowed serialization using the DataContract serializer.
Comments: ** Comment from web user: GaussZ **

Forgot to add: The reason for this work item is to request integrating the change into interlinq :)

CREATED ISSUE: SerializableExpression not serializable with DataContractSerializer

GaussZ — Thu, 05 Jun 2008 16:58:24 GMT

CREATED ISSUE: Bug with Anonymous types and hashcodes

markalroberts — Tue, 29 Apr 2008 19:17:25 GMT

After several thousand queries using anonymous types, the server-side of interlinq became unbelievably slow. I tracked this down the the fact that it's emitting a new dynamic type each and every time the query is called and not reusing the cached types at all.

The reason is that the GetHashCode is not being calculated correctly in AnonymousMetaType

num ^= EqualityComparer<List<AnonymousMetaProperty>>.Default.GetHashCode( this.m_metaProperties );

is actually comparing with the instance of List<AnonymousMetaProperty>, which is always different.

this.m_metaProperties.ForEach((o) => num ^= EqualityComparer<AnonymousMetaProperty>.Default.GetHashCode(o));

solves the problem. You need to do the same in InterLinqType; replace

num ^= EqualityComparer<List<InterLinqType>>.Default.GetHashCode( this.m_genericArguments );

with

this.m_genericArguments.ForEach((o) => num ^= EqualityComparer<InterLinqType>.Default.GetHashCode(o));

CREATED ISSUE: Bug with visiting null constant expressions

markalroberts — Tue, 29 Apr 2008 10:33:43 GMT

Hi - there is a minor bug with the visiting of constant expressions when the value is null - the code is this:

protected override Expression VisitSerializableConstantExpression( SerializableConstantExpression expression ) {
return Expression.Constant(expression.Value);
}

In the case of null, since there is no way for the Expression factory to know the type it defaults to system.object. The can cause other things to break. I changed the code to specify the CLR type as follows, and it works for the Null case:

protected override Expression VisitSerializableConstantExpression( SerializableConstantExpression expression ) {
if (expression.Value != null)
{
return Expression.Constant(expression.Value);
}
else
{
return Expression.Constant(expression.Value, (Type)expression.Type.GetClrVersion());
}
}

Thanks, Mark.

NEW POST: Possibilities of making InterLINQ work with Dynamic LINQ?

markalroberts — Wed, 23 Apr 2008 14:14:37 GMT

Hi,

I've been experimenting with your excellent code - very good!

One thing I would really like to do to increase efficiency and further cut down network traffic is to introduce dynamic SQL into the mix. (i.e., on the client, if the user is only showing columns "Id" and "Name", then I would like to utilise the Dynamic code examples here:

http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx

to produce a query like this:

var customers = context.Customers();
var customerView = customers.Select("New(Id, Name)";

Unfortunately, because the dynamic linq code emits new classes in runtime, the WCF serializer breaks down when trying to send the expression tree to the server for evaluation (it tries to find the dynamically created assembly as a physical dll)

Any thoughts here would be most appreciated!

Thanks,
Mark

CREATED ISSUE: Bug with creating arrays

markalroberts — Tue, 22 Apr 2008 14:42:49 GMT

When sending a query using contains, an exception is raised. The problem appears to be here:

/// <summary>
/// Visits a <see cref="SerializableNewArrayExpression"/>.
/// </summary>
/// <param name="expression"><see cref="SerializableNewArrayExpression"/> to visit.</param>
/// <returns>Returns the converted <see cref="Expression"/>.</returns>
protected override Expression VisitSerializableNewArrayExpression( SerializableNewArrayExpression expression ) {
if( expression.NodeType == ExpressionType.NewArrayBounds ) {
return Expression.NewArrayBounds( (Type) expression.Type.GetClrVersion(), VisitCollection<Expression>( expression.Expressions ) );
}
return Expression.NewArrayInit( (Type) expression.Type.GetClrVersion(), VisitCollection<Expression>( expression.Expressions ) );
}

And seems to be fixed by using the GetElementType() of the CLR Type thus:

/// <summary>
/// Visits a <see cref="SerializableNewArrayExpression"/>.
/// </summary>
/// <param name="expression"><see cref="SerializableNewArrayExpression"/> to visit.</param>
/// <returns>Returns the converted <see cref="Expression"/>.</returns>
protected override Expression VisitSerializableNewArrayExpression( SerializableNewArrayExpression expression ) {
if( expression.NodeType == ExpressionType.NewArrayBounds ) {
return Expression.NewArrayBounds(((Type)expression.Type.GetClrVersion()).GetElementType(), VisitCollection<Expression>(expression.Expressions));
}
return Expression.NewArrayInit(((Type)expression.Type.GetClrVersion()).GetElementType(), VisitCollection<Expression>(expression.Expressions));
}

Thanks,
Mark.

UPDATED WIKI: Home

domcon — Thu, 27 Mar 2008 10:27:32 GMT

Project Description

InterLINQ is an IQueryable Provider implementation. LINQ stands for Language Integrated Query and is one of the most important and powerful features of the new .NET 3.5 Technology. A LINQ Query is represented by an Expression Tree.

Multi-Tier functionality is not provided by LINQ, but this new technology makes it possible by serializing a the Expression Tree of the LINQ Query and sending it to a WCF Service. The Remote Service deserializes this Expression Tree and starts the execution. Return value of the Remote Service's called method is the result of the executed query.

Sample Usage

One of the goals in this project is to the behaviour like in LINQ to SQL. Here an example how to use InterLINQ.

Client

// Connect to the server
ClientQueryWcfHandler clientQueryHandler = new ClientQueryWcfHandler();
clientQueryHandler.Connect();
 
// Create a context
SimpleExampleContext simpleExampleContext = new SimpleExampleContext( clientQueryHandler );
 
// Use LINQ as usual
var selectAllSimpleObjects = from so in simpleExampleContext.SimpleObjects
                              select so;
...

Server

// Get a IQueryHandler (see for adapters to LINQ to Objects, LINQ to SQL, etc.)
IQueryHandler queryHandler = new ObjectQueryHandler( new ExampleObjectSource() );
 
// Publish the service
using( ServerQueryWcfHandler serverQueryHandler = new ServerQueryWcfHandler( queryHandler ) ) {
    serverQueryHandler.Start();
    Console.ReadLine();
}

Features

All features of LINQ!
Querying of anonymous types ( select new { ... } )
Adapter for several LINQ technologies.
Will be built into a future Version of pmMDA.net (pmmda-net.sourceforge.net). This enables Change Tracking and Write Access.

Status

InterLINQ 0.2 Released

Authors

Pascal Schaefer

Software developer at Geberit International AG (http://www.geberit.com)

Manuel Bauer

Research associate at Institute of Networked Solutions INS at University of Applied Sciences of Eastern Switzerland (Rapperswil) (http://ins.hsr.ch/)
Swiss Software Solution Center (http://www.s3cc.ch/)

NEW POST: Examples for usage of Interlinq and L2E

mahmoodvcs — Sat, 15 Mar 2008 11:18:00 GMT

Hi.
How can I use InterLINQ in a WCF service hosted in IIS.
Can anyone help me please. I'm a little bit confused.

NEW POST: Examples for usage of Interlinq and L2E

mark0790 — Tue, 19 Feb 2008 17:14:33 GMT

Do you mean new EntityFrameworkQueryHandler passing in my ObjectContext to the constructor?

NEW POST: Inserts, Deletes etc.

Xelluloid — Tue, 19 Feb 2008 12:37:24 GMT

Hi,

I want to ask, if there will be the possibility of Inserts and Deletes on DataContexts with Interlinq.

Greets

Sebastian

NEW POST: InterLinq and LINQ2SQL Auto generated classes

Xelluloid — Tue, 19 Feb 2008 11:00:53 GMT

sry, I posted it twice

NEW POST: InterLinq and LINQ2SQL Auto generated classes

Xelluloid — Tue, 19 Feb 2008 11:00:49 GMT

Atmospherian wrote:

domcon wrote:
Hi

InterLINQ doesn't solve the problem of serializing the querys result. The main target of InterLINQ is to transfer queries to the server and execute them.
I think there is a way to send the classes created from a .dbml file over network. The main problem is the serialization of the EntitySet and EntityRef classes.
I'm not up to date on this problem but have a look at my favorite blog for .NET and LINQ: http://oakleafblog.blogspot.com/

Greetings

doMCon

after some more research, i realized that the solution to my problem of not being able to send query results to a client via WCF was the simple fact that i did not enable unidirectional serialization on my dbml. once i did that i was very easily able to execute a query on the server and send the results to the client.

thanks for your reply and perhaps in the future i will need to take another look at InterLINQ.

Excellent, it solved my problem as well, as i tried to send a query to the server and then send the result to the client, so I used Interlinq to send the Query and by using unidirectional serialization, the Server could send the result to the client.
Also thanks

NEW POST: InterLinq and LINQ2SQL Auto generated classes

Atmospherian — Mon, 18 Feb 2008 14:02:38 GMT

NEW POST: InterLinq and LINQ2SQL Auto generated classes

domcon — Mon, 18 Feb 2008 07:21:52 GMT

Hi

InterLINQ doesn't solve the problem of serializing the querys result. The main target of InterLINQ is to transfer queries to the server and execute them.
I think there is a way to send the classes created from a .dbml file over network. The main problem is the serialization of the EntitySet and EntityRef classes.
I'm not up to date on this problem but have a look at my favorite blog for .NET and LINQ: http://oakleafblog.blogspot.com/

Greetings

doMCon

NEW POST: InterLinq and LINQ2SQL Auto generated classes

Atmospherian — Sun, 17 Feb 2008 15:26:01 GMT

Hi There,

I just stumbled upon your wonderful project while trying to find a way to send query results from a server to a client using a web service. I've taken a look at your examples and noticed that the base object you send has some attributes placed on the class itself and its members. my question is, will InterLinq work with the dynamically generated classes created from a .dbml file? modifying the classes that are generated isnt the best idea because they will most likely be overwritten if the object model needs to be modified.

is there currently a solution for this scenario? or is this a future feature?

Thanks in advance for your kind consideration.