Well, hi.

 

thanks to Mike.Griffin's help, I managed to work around using owners in SQL. As we all now, only SQL databases use owners, and the syntax is as follows:

 

Owner.Table

 

Now, EntitySpaces generates the query like, for example

 

select * from  [table]

 

Now, this query works perfectly. When you work with owners, you need to change the querysource, like

 

collection.Query.es.QuerySource = "Owner.Table";

 

However, what happens now if you run the query?

 

select * from [Owner.Table]

 

Which SQL DOESNT like, it doesnt work in SQL. SQL's select's on table's with owners is as follows:

 

select * from [owner].[table]

 

therefore, i had to manually edit the QuerySource string to get it to run the queries to this string: "Owner].[Table", now, the resultant query is:

 

select * from [Owner].[Table]

 

which works perfectly :) Just thought I'd mention it, for future reference to any of the people that try to work with owners, since it actually took me quite a long time to figure it out. And perhaps for EntitySpaces to take in as a happy suggestion.

 

Cheers on a great system guys. :D, loving every bit of entitySpaces i've used so far.