[dba-VB] C# - Direct data manipulation

Gustav Brock Gustav at cactus.dk
Fri Dec 4 06:33:36 CST 2009


Hi John

Oh, I misunderstood you.
Not until recently. Skipping the SQLCommand low-level stuff completely, I've used datatables with in-line SQL queries (to avoid designing T-SQL and special views - Shamil mobbed me for that choice!) and I have been busy learning just these - so one step further, no thanks. Also, I had a hard time grasping the lambda expressions and syntax and still feel I have a lot to learn. Yes, you can use LINQ without lambda, but that seems like LINQ without an arm and a leg. But - for anything else than some special cases like perhaps your cases - I'm confident LINQ is the route to follow.

/gustav


>>> jwcolby at colbyconsulting.com 04-12-2009 12:53 >>>
I really meant do you use linq in your C# apps?

John W. Colby
www.ColbyConsulting.com 


Gustav Brock wrote:
> Hi John
> 
> Yes and no. I used an old version for some time but the current version is more powerful.
> 
> Please note that it comes with all the examples from his book, and even without the book this is a great why to get your hands on LINQ as the code is "live" - no need to copy and paste, it is right there for you try out at once.
> 
> /gustav 
> 
>>>> jwcolby at colbyconsulting.com 02-12-2009 19:46 >>>
> Do you use it?
> 
> John W. Colby
> www.ColbyConsulting.com 
> 
> 
> Gustav Brock wrote:
>> Hi John et al
>>
>> Don't forget LINQPad.
>>
>> Why LINQ beats SQL:
>> http://www.linqpad.net/WhyLINQBeatsSQL.aspx 
>>
>> /gustav
>>
>>
>>>>> Gustav at cactus.dk 02-12-2009 08:19 >>>
>> Hi John
>>
>> As I see it, that would be LINQ and ADO.NET EF (Entity Framework). Not that I have used these in a scenario even "remotely close" to yours, but the fine thing is that is performs all the plumbing behind the scene - generates the SQL for you. Critics tell that this SQL could be long-winded (= not optimized) but what do I care? If it flips 17 or 87 switches does nothing to me as long as the result is fast and precise.
>>
>> ADO.NET EF is an amazing piece of work. It is not mature but if MS continues to evolve it with the same speed as Silverlight I'm sure it will catch up.
>>
>> /gustav






More information about the dba-VB mailing list