Re: [ADVANCED-DOTNET] Accent Insensitive CultureInfo (or at least DataTable.Select)

2008-06-04 Thread Peter Ritchie
As far as I've been able to tell, you can't create a CompareInfo that causes diacritics to be ignored on comparison (which means you can't create a CultureInfo to do the same). You can create something that will sort as if diacritics weren't there... As far as I can tell the only way to compare t

Re: [ADVANCED-DOTNET] Accent Insensitive CultureInfo (or at least DataTable.Select)

2008-06-04 Thread Joel Paula
Thanks for your interest. I can build any CultureInfo, but the problem is with CompareInfo. I am not able to create a CompareInfo class. I think that if I was able to create one, I would make it so that it ignores Accents. Any ideas? Joel On Wed, 4 Jun 2008 08:01:27 -0500, Booth, Bill <[EMAIL P

Re: [ADVANCED-DOTNET] Accent Insensitive CultureInfo (or at least DataTable.Select)

2008-06-04 Thread Booth, Bill
Have you looked into creating a custom culture using the CultureAndRegionInfoBuilder class? -Original Message- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Joel Paula Sent: Tuesday, June 03, 2008 16:33 To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject:

Re: [ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Frans Bouma
> Thanks again, I'm using LLBGen as we speak - it's cutting down my > workload by several hours! Thanks for the great feedback, Ben! :) FB ps, it's LLBLGen, with 3 L's. Yes, I know the name isn't the greatest ;) ---

Re: [ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Ben Joyce
Thanks again, I'm using LLBGen as we speak - it's cutting down my workload by several hours! Ben On Wed, Jun 4, 2008 at 12:26 PM, Phil Sayers <[EMAIL PROTECTED]> wrote: > There are a few procuts that can help you with this. > > CodeSmith > MyGeneration > LLBgen > > I've missed many I'm sure, but

Re: [ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Phil Sayers
There are a few procuts that can help you with this. CodeSmith MyGeneration LLBgen I've missed many I'm sure, but these are the few that immediately spring to mind. A great book about code generation is "Code Generation in Microsoft.Net" by Kathleen Dollard. -Original Message- From: Di

Re: [ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Ben Joyce
Just checked out LLBGen - this is exactly what I'm after - many thanks! Ben On Wed, Jun 4, 2008 at 9:21 AM, Iain Smallwood <[EMAIL PROTECTED]> wrote: > These things are known as Object Relational Mappers. > > http://en.wikipedia.org/wiki/Object-relational_mapping > > If you have not gone in any p

Re: [ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Iain Smallwood
These things are known as Object Relational Mappers. http://en.wikipedia.org/wiki/Object-relational_mapping If you have not gone in any particular direction and can use Visual Studio 2008 the LINQ (to SQL) stuff baked in could be of use - you can use an MS command line tool called SQLMetal to gen

Re: [ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Ben Joyce
Many thanks for the quick response. I appreciate the "google" suggestion... i wasn't sure what to google for :) I'll check out your suggestions. Thanks Paul. Ben On Wed, Jun 4, 2008 at 9:03 AM, Paul Cowan <[EMAIL PROTECTED]> wrote: > There are 100s > > Try googling.I use mygerneration to do NH

Re: [ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Paul Cowan
There are 100s Try googling.I use mygerneration to do NHibernate files.There is codesmith etc., etc., [EMAIL PROTECTED]> Date: Wed, 4 Jun 2008 09:00:49 +0100> From: [EMAIL PROTECTED]> Subject: [ADVANCED-DOTNET] Automated DB Class Creation> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM> > hi all.> >

[ADVANCED-DOTNET] Automated DB Class Creation

2008-06-04 Thread Ben Joyce
hi all. apologies if this is the wrong list to ask on... does anyone know of a tool that can create a VB class with all the properties, variables and maybe even New,Update,Delete functions based on a DB table? doing this manually for each object/dataset is quite laborious - thought maybe there m