Re: Advice for Data Access - Hibernate/Linq/Fluent/etc

Nic Roche wrote: http://msdn.microsoft.com/en-us/vcsharp/bb688085.aspx Nic http://msdn.microsoft.com/en-us/vcsharp/bb688085.aspx == http://msdn.microsoft.com/en-us/vbasic/bb688085.aspx I think the 'vcsharp' and 'vbasic' directories are just virtual dirs meant for making more readable/sear

RE: Advice for Data Access - Hibernate/Linq/Fluent/etc

http://msdn.microsoft.com/en-us/vcsharp/bb688085.aspx Nic Subject: RE: Advice for Data Access - Hibernate/Linq/Fluent/etc Date: Wed, 14 Jul 2010 10:47:56 +1000 From: ben.robb...@jlta.com.au To: ozdotnet@ozdotnet.com Great link Corneliu, do you know if there is an equivalent page for C#?

Re: [OT] My Win 7 PC too slow

7.6 - OCZ Vertex 2 120GB SSD. I bought it a few weeks ago from PCCG for $519. Worth every cent. Plus I can now do a celebratory dance with my laptop when things go right, without any consequences :) On 14 July 2010 13:29, David Burstin wrote: > > 7.1 - I have a Falcon 128gb SSD. Love it. > > On

RE: Advice for Data Access - Hibernate/Linq/Fluent/etc

llblgen From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Michael Minutillo Sent: Wednesday, 14 July 2010 12:52 PM To: ozDotNet Subject: Re: Advice for Data Access - Hibernate/Linq/Fluent/etc +1 for LINQPad and LINQ. If you do try LINQPad (which is

RE: Advice for Data Access - Hibernate/Linq/Fluent/etc

It also gave you a 1:1 table to object mapping. End result is usually either a lousy database design or a lousy object model. Regards, Greg From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Wednesday, 14 July 2010 1:03 PM To: 'ozDot

Re: Advice for Data Access - Hibernate/Linq/Fluent/etc

Currently using EntitySpaces 2010 for our data access layer http://www.entityspaces.net/Portal/Default.aspx Has support for LINQ. Very happy with the product. Support is great. Does cost, unlike nHibernate, but its not that expensive. You could also check out lightspeed (http://www.mindscape

RE: Advice for Data Access - Hibernate/Linq/Fluent/etc

Get a hold of LinqPAD (www.linqpad.net) and you won't look back. Great for learning LINQ and for experimenting. Having spent a lot of yesterday trying to get a .nettiers project compiling, I'm so thankful for LINQ. I have enjoyed the way the netTiers generated classes are binary seriali

Re: Advice for Data Access - Hibernate/Linq/Fluent/etc

+1 for LINQPad and LINQ. If you do try LINQPad (which is free) then I highly recommend purchasing the $20 IntelliSense add-on. Especially if you are just getting starting in LINQ. In the interests of full-disclosure, Joe (the author of LINQPad) is a friend but I use LINQPad as a general snippet c

RE: Batching ids for submitting to a stored proc

There are good relevant discussions re this on Erland's site: http://www.sommarskog.se/ Regards, Greg From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tony Wright Sent: Wednesday, 14 July 2010 10:49 AM To: 'ozDotNet' Subject: RE: Batching ids for s

RE: Advice for Data Access - Hibernate/Linq/Fluent/etc

+1 for LINQPad From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Dylan Tusler Sent: Wednesday, 14 July 2010 10:20 To: 'ozDotNet' Subject: RE: Advice for Data Access - Hibernate/Linq/Fluent/etc Get a hold of LinqPAD (www.linqpad.net) and you won't look b

RE: Batching ids for submitting to a stored proc

That is my traditional method, although building a string of comma delimited ids isn't exactly type safe. My existing client uses the xml method. I seem to recall seeing a sql trace where a temporary table was populated and then a stored proc was called all in the same transaction. I was ac

RE: Advice for Data Access - Hibernate/Linq/Fluent/etc

Get a hold of LinqPAD (www.linqpad.net) and you won't look back. Having spent a lot of yesterday trying to get a .nettiers project compiling, I'm so thankful for LINQ. Dylan. From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@

RE: Advice for Data Access - Hibernate/Linq/Fluent/etc

Great link Corneliu, do you know if there is an equivalent page for C#? After a bit of Googling and browsing the closest I got was this: http://msdn.microsoft.com/en-us/vcsharp/aa336746.aspx Ben From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-bou

Re: Batching ids for submitting to a stored proc

StackOverflow has a lot to say on this: http://stackoverflow.com/questions/337704/parameterizing-a-sql-in-clause -- Regards, Mark Hurd, B.Sc.(Ma.)(Hons.)

RE: Batching ids for submitting to a stored proc

I've written a user defined function that takes a delimited string and delimiter as arguments and return a table containing the delimited values. You can use this inline in your proc in joins etc. I haven't noted any performance hit doing it this way. K... __

Re: Batching ids for submitting to a stored proc

What is so costly and not maintainable about passing xml (possibly bound to a schema)? On Wed, Jul 14, 2010 at 9:54 AM, wrote: > Just prepare the procedure and call it repeatedly without closing or removing > the command object. Passing a load of values as an xml or as a delimited > parameter

Re: Batching ids for submitting to a stored proc

Just prepare the procedure and call it repeatedly without closing or removing the command object. Passing a load of values as an xml or as a delimited parameter is costly and not maintainable. Davy --Original Message-- From: ton...@tpg.com.au Sender: ozdotnet-boun...@ozdotnet.com To: oz

Batching ids for submitting to a stored proc

Hi all, I have a scenario as follows. I'm interested to hear what other people do to solve this problem. I have two Checkbox Lists. The left Checkbox list is Customers. The right Checkbox list is Shops. On clicking the checkboxes in the left Customers Checkbox list, it posts back and calls a

Re: Advice for Data Access - Hibernate/Linq/Fluent/etc

I think the simplest/lightest/quickest way to craft an ORM over a DB is LINQ to SQL. You can't make it any simpler that than. I don't understand why MS stopped developing. They try too hard to move in the "we love everyone and every db camp at the expense of our own SQL". Have this page open all

Re: Advice for Data Access - Hibernate/Linq/Fluent/etc

Hi Les I my opinion LINQ is worth the learning curve because it allows fairly rapid development of applications compared to an application with dedicated business objects and associated stored procedures. We code generate all of our data acces objects and stored procedures but when there's a chang

Advice for Data Access - Hibernate/Linq/Fluent/etc

Hi All, I'm about to start working on a mid-sized data-centric app (accounting area) which is mostly just lots of forms which display data, edit/write data, and then spitting out some pretty reports, etc with the data sitting in SQL Server. (Think of old-school MSaccess apps) Wanting to av

RE: Refactoring linq Query Expression

Hi Arjang, What about this: private Func, IQueryable> _getBoiFg = qs => from c in qs where c.DATAAREAID == "boi" && c.ITEMGROUPID == "fg" select c; public List GetAll() { using (var ctx = new DataEntities()) { ret

Re: Refactoring linq Query Expression

Intresting, but I was trying to have a most general expression and restrict it as I went along. This example turns that idea upside down on it's head. None the less it is a valid solution, gives a glimpse to a completely different class of solutions where one might start with the most restricted s

RE: Refactoring linq Query Expression

Nice. how about: public class Product { public List GetAll() { return GetAllContaining(null); } public List GetAllContaining(string needle) { DataEntities ctx = new DataEntities(); { var qry = from c in ctx.Products

Re: Refactoring linq Query Expression

On Tue, Jul 13, 2010 at 5:06 PM, Michael Minutillo wrote: > You could do this: Mm, good change. > -- > Michael M. Minutillo > Indiscriminate Information Sponge > Blog: http://wolfbyte-net.blogspot.com -- silky Every morning when I wake up, I experience an exquisite joy — the joy of being th

Re: Refactoring linq Query Expression

On Tue, Jul 13, 2010 at 5:02 PM, Arjang Assadi wrote: > Greetings, > > I am trying to factor out the qry from GetAll and reuse it (instead of > copy and pasting ) in GetAllContaining(needle). > Here is the code: (any other points is also welcomed :) I don't know much about anything but that gener

Re: Refactoring linq Query Expression

You could do this: public class Product { public List GetAll() { DataEntities ctx = new DataEntities(); { var qry = from c in InnerQuery(ctx) select c; return qry.ToList(); } } public List GetAllContaining(string needle)

Refactoring linq Query Expression

Greetings, I am trying to factor out the qry from GetAll and reuse it (instead of copy and pasting ) in GetAllContaining(needle). Here is the code: (any other points is also welcomed :) public class Product { public List GetAll() { DataEntities ctx = new DataEntities(); {