LINQExtender

Created Issue: Support for OR in Where expression

theblacklabrador — Thu, 04 Dec 2008 20:05:50 GMT

The multiple where clause improvement is great. Even better would be support for OR in the where clause - if I understand it correctly it only supports AND currently.

Commented Feature: Join support to LinqExtender

smoldok — Wed, 03 Dec 2008 18:45:53 GMT

Add a join of objects and property interface in LinqExtender.
Comments: ** Comment from web user: smoldok **

As I see it, a join is a subquery filtered by the first query value. So when the primary query is loading it have to execute a secondary query for each item.
So maybe an event can be fired every time an item is added to the IModify and in that event the Process method is called for each child or maybe a new method similar to the Process but that receive the filter.

Commented Issue: QueryObjectBase and a IQueryObjectBase interface

smoldok — Wed, 03 Dec 2008 18:15:56 GMT

Hi, It is possible to change the QueryObjectBase class to be an interface and then have an abstract class that implement it and a QueryObjectBaseDefault a class that just derive from it with out any changes?

I have my objects that already derive from a class and I can not change that, but I can add an interface and then implement each method of the interface calling the internal QueryObjectBaseDefault object.
Also my objects have an internal way to identify the columns and I will like to not use attributes for that.
If it is possible I will like to override the FillBucket method because I don't want to use attributes, if bucket also implement interfaces an the bucket item too, then the overriding will be much easier.
thanks.
Comments: ** Comment from web user: smoldok **

Answering you question about why I don't need the attributes.
I don't need them because my class already has a way to return the columns names and PK items and
will be more correct in my case to re use my class methods than add attributes.
If everything is an interface and an implementing abstract class and default model class that will make the LinkqExtender more flexible. It will support the same functionality as today but if some one need to replace a little piece of code will be easy to do.

New Post: QueryObjectBase and a IQueryObjectBase interface

mehfuzh — Wed, 03 Dec 2008 17:46:50 GMT

This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.

Created Issue: QueryObjectBase and a IQueryObjectBase interface

mehfuzh — Wed, 03 Dec 2008 17:46:50 GMT

New Post: QueryObjectBase and a IQueryObjectBase interface

mehfuzh — Wed, 03 Dec 2008 17:46:27 GMT

I can convert it to IQueryObject but why you dont need attributes If you dont use them then by default it will take property names as BucketItem.Name. There are few attributes which are for modifying the behavior of the class and nothing else. Of course there is one property that must be put on top of one of the property that will be the unique item for your object so that any update to that object is tracked and backed to repository when you do db.submitChanges();

Hope that helps,

Commented Feature: Join support to LinqExtender

mehfuzh — Wed, 03 Dec 2008 17:41:33 GMT

Add a join of objects and property interface in LinqExtender.
Comments: ** Comment from web user: mehfuzh **

Not yet.. i am plannig two way One is auto like LINQToFlickr like API where it will join for you on your behalf and will know on which key to join, Any Particular idea is greatly apreciated !

New Post: QueryObjectBase and a IQueryObjectBase interface

smoldok — Tue, 02 Dec 2008 22:01:49 GMT

Commented Feature: Join support to LinqExtender

smoldok — Tue, 02 Dec 2008 21:42:44 GMT

Add a join of objects and property interface in LinqExtender.
Comments: ** Comment from web user: smoldok **

Hi, Is the Join already supported in the 1.4.x version?

Updated Release: LinqExtender (1.4) (Aug 11, 2008)

mehfuzh — Thu, 23 Oct 2008 06:20:39 GMT

New Enhanced Object tracking service (OTS)

A. Update Tracking

Take this example

Book book = (from book in context.Books
where book.Id = 1 ).Single();

// now update a property
book.ISBN = "110";
//then call
context.SubmitChanges();

LinqExtender knows the object is updated and thus will call Query<T>.UpdateItem(Bucket). So, in your provider to support
object update you need to override the following

protected bool UpdateItem(Bucket item)
{ 
    Bucket contains the updated property- value map
   
    //finally do a return , if true, then only the
    //collection will be updated or 
    //it will revert back to the old one and raise an OnError event.
    return true/false;   
}

B. Get by Idenitty

 
protected override T GetItem(Bucket item)
{
   T singleObject = GetItThoughUniqueValue(...);
   return singleObject;
}

This will be called by the toolkit for queries like

var query = from book in context.Books
where book.Id == 1
select book

Book book = query.Single();

Here, Id is a unique field defined by UniqueIdentifier attribute. This saves few if-elses in Query<T>.Process. when getting single unique item. If you are writting a provider that auto generates the query depending on Bucket properties, you can do that well with Quey<T>.Process and in that case you dont need override this for Identity calls, but if your building a serviced API like LINQToFlickr and you want your GetById and Search in differnent scope rather using IF-ELSE-THEN in Query<T>.Process , then it will be useful.

C. Update with item add tracking
In query object for tracking new object you dont need to override the IsNew property of QueryObjectBase anymore to identify if an object is new or not.

Finally, the return type of AddItem, UpdateItem, RemoveItem is changed from void to bool, which requires you to do success check and return a bit status , status := false will ensure the main query collection is not updated with user changes and will raise proper a OnError event.

Others
1. Use bucket.Items...IsUniqe and bucket.UniqueItems to check for properties with UniqueIdentifierAttribute
2. Added OriginalEnityName attribute for class like the OrignalFieldName for propeties. If you have table name other than class name You can use this attribute to map it with original table name.
In that case bucket.Name == the attribute name.

Patch 1.4.1 update 23 Oct, 2008

Fixed Complex member access issue in orderby clause
Added Bucket.FindAttribute for queryting custom object attributes.

Example

DbTypeAttribute attribute = (DbTypeAttribute)item.FindAttribute(typeof(DbTypeAttribute));

Added auto table creation (from config: executeDDL = true) for OpenLInqToSql sample ORM.

Released: LinqExtender (1.4) (Aug 11, 2008)

Thu, 23 Oct 2008 06:20:38 GMT

protected bool UpdateItem(Bucket item)
{ 
    Bucket contains the updated property- value map
   
    //finally do a return , if true, then only the
    //collection will be updated or 
    //it will revert back to the old one and raise an OnError event.
    return true/false;   
}

B. Get by Idenitty

 
protected override T GetItem(Bucket item)
{
   T singleObject = GetItThoughUniqueValue(...);
   return singleObject;
}

Fixed Complex member access issue in orderby clause
Added Bucket.FindAttribute for queryting custom object attributes.

Example

DbTypeAttribute attribute = (DbTypeAttribute)item.FindAttribute(typeof(DbTypeAttribute));

Added auto table creation (from config: executeDDL = true) for OpenLInqToSql sample ORM.

Updated Release: LinqExtender (1.4) (Aug 11, 2008)

mehfuzh — Thu, 23 Oct 2008 06:19:42 GMT

protected bool UpdateItem(Bucket item)
{ 
    Bucket contains the updated property- value map
   
    //finally do a return , if true, then only the
    //collection will be updated or 
    //it will revert back to the old one and raise an OnError event.
    return true/false;   
}

B. Get by Idenitty

 
protected override T GetItem(Bucket item)
{
   T singleObject = GetItThoughUniqueValue(...);
   return singleObject;
}

DbTypeAttribute attribute = (DbTypeAttribute)item.FindAttribute(typeof(DbTypeAttribute));

Added auto table creation (from config: executeDDL = true) for OpenLInqToSql sample ORM.

Updated Release: LinqExtender (1.4) (Aug 11, 2008)

mehfuzh — Thu, 23 Oct 2008 06:17:14 GMT

protected bool UpdateItem(Bucket item)
{ 
    Bucket contains the updated property- value map
   
    //finally do a return , if true, then only the
    //collection will be updated or 
    //it will revert back to the old one and raise an OnError event.
    return true/false;   
}

B. Get by Idenitty

 
protected override T GetItem(Bucket item)
{
   T singleObject = GetItThoughUniqueValue(...);
   return singleObject;
}

Patch update 23 Oct ,2008*

Fixed Complex member access issue in orderby clause
Added Bucket.FindAttribute for queryting custom object attributes.
Example

DbTypeAttribute attribute = (DbTypeAttribute)item.FindAttribute(typeof(DbTypeAttribute));

Added auto table creation (from config: executeDDL = true) for OpenLInqToSql sample ORM.

Source code checked in, #13333

mehfuzh — Thu, 23 Oct 2008 05:59:46 GMT

Updated the readme

Source code checked in, #13332

mehfuzh — Thu, 23 Oct 2008 05:47:34 GMT

Createing a patch for upload in the release.

Source code checked in, #12959

mehfuzh — Sun, 19 Oct 2008 19:53:45 GMT

More fix over prevoious commit.

Source code checked in, #12957

mehfuzh — Sun, 19 Oct 2008 19:49:10 GMT

Fix: orderby can take complex memeber aceess arguments. like: orderby order decending [ PhotoOrder order = PhotoOrder.LastUpdated]

Source code checked in, #12831

mehfuzh — Wed, 15 Oct 2008 19:13:35 GMT

fix : duplicate value problem caused by last changes

Source code checked in, #12687

mehfuzh — Sat, 04 Oct 2008 20:02:03 GMT

Refactor for support multiple bucket in one instance, will be used for join

Project License Changed

Wed, 24 Sep 2008 11:36:08 GMT

Copyright (c) 2007-2008 LinqExtender Tookit Project Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.