A&O Pablo Iñigo 2008-08-18: Integration: System.Data.Linq & DbLinq

[Pablo Iñigo Blasco]

ACHIEVEMENTS

* To implement Math functions support (abs, exp, floor, ln, log, pow, round, sign, sqrt)  (special attention to sqlserver vendor)
[DONE, but some problems yet with round function sql translation]

* To implement string.TrimStart, string.TrimEnd functions support
[DONE]

* To continue with the third last week objective: To fix existing tests: making them more coherent regards CLR/System.Data.Linq.dll (this assembly should pass all test, currently it doesn't do it)
[NO PROGRESS]

* To implement TimeSpan.Days/TotalDays/Hour/

TotalHour/Minutes/TotalMinutes/Seconds/TotalSeconds/Milliseconds/TotalMilliseconds support
(special attention to sqlserver vendor)
[DONE]

* To implement DateTime Add and Diff functions support
(special attention to sqlserver vendor)
[DONE]

* To check differences between sqlserver and sqlserver express, create a new provider if it is necessary and implement each method.
[DONE, I have tested over a sqlserver 2005 and everything seems work with the same behaviour than SqlServerExpress]

* To design and implement improvements in expressions executed by the runtime (optimization stage). (Nonetheless I have to propose it in the DbLinq list)
[NOT DONE]

BONUS:
* Some patches for solving problems about object-tracking stuff.
[http://groups.google.com/group/dblinq/browse_thread/thread/fb462d53a97b891]
* System.Data.Linq.Binary implementation


GSOC has ended so there aren't new objectives for the next week. Nonetheless that doesn't mean that I won't do anything about this project, I'll continue from tomorrow has a normal contributor to the DbLinq and Mono project. During these tree month I have learnt a lot about the System.Data.Linq so I am sure that I can be very useful for Mono in the implementation of Mono-System.Data.Linq/DbLinq and other stuff. I won't be absoluly satisfied until see such namespace fully implemented ;-)

Regards.