StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » How to check for duplicates on current business object

How to check for duplicates on current business object

Ger Cannoll — Tue, 26 Jul 2011 11:05:27 GMT

I am using a BO with multiple rows taken from the Database Table and want to ensure that I do not have any duplicates (On the BO) before I save.

If I was doing this against the database Table, I would issue someting like:

Select Country , Count(Country) as MyCount from MyTable Group by Country and then Test that myCount was not greater than 1

Is there any similar construct I can use for Business Object i.e. be able to search through the BO and let it throw up any duplicates.

RE: How to check for duplicates on current business object

Edhy Rijo — Tue, 26 Jul 2011 11:05:27 GMT

Hi Gerard,

I compiled all my SF application with .Net 4 runtimes, it is much better, faster and reliable than 2.0, also there are new functionality in version 4 that does not exist in the previous one, so you can go ahead and use 3.5 or better yet 4.

I had used Linq briefly in one of my applications and yes it is very nice and will get you the results you are looking for, so go ahead and use it without hesitation.

RE: How to check for duplicates on current business object

Ivan George Borges — Tue, 26 Jul 2011 07:47:22 GMT

Sorry, but I am affraid I have no expertise on the subject to give you a more accurate answer.

Maybe someone else will chime in and help you with that. You could also run a test on different approaches and decide which goes better for your conditions.

RE: How to check for duplicates on current business object

Ger Cannoll — Tue, 26 Jul 2011 06:59:52 GMT

Hi Ivan.

I have just started to play around with Linq statements (from a Datatable) and it appears to be quite easy to 'Group By' using the Inernal Table from the BO. In that Linq stuff only came in in .Net 3.5 , would you anticipate any problems using this with SF (I had any projects running on Net 2) . I have changed the Project to 3.5 and have not noticed any problems yet. I would imagine that a Linq group By Statement might be faster than itrating through each BO and doing a search for a duplicate on each row. The particular maintanance forms that I want to validate could have thousands of rows so speed will be a factor

RE: How to check for duplicates on current business object

Ivan George Borges — Mon, 25 Jul 2011 16:22:40 GMT

OK Gerard. Sorry, I thought you wanted a BO free of the duplicates. In fact you want the ones that are duplicates.

There might be easier ways to do it, but I would iterate through your BO and check each row if there is any other with the same content. Everytime I found one, I would store it in some kind of array, collection or even another instance of the same BO.

To look for duplicates, you can use the BO.CurrentDataTable.Select function, as in:

MyBO.CurrentDataTable.Select("MyColumnName = " & MyColumnCurrentValue & " AND MyPrimaryKeyColumnName <> " & MyCurrentPrimaryKeyValue).Length

If this line returned anything greater than 0 this would tell you this row had a duplicate and you could add it to your DuplicatesBO to show the user once finished.

RE: How to check for duplicates on current business object

Ger Cannoll — Mon, 25 Jul 2011 14:54:38 GMT

Hi Michel. Thanks for your reply.

This looks like what I want, but I see its another chargeable piece of software (Not that much I admit but all the bits are starting to add up (e.g. Vis Studio, SF,DEVEX Grid, Devex Reports, Excel Creator etc and 3 or 4 other bits and pieces... its starting to get a bit difficult to keep track of them all !!......). I will try to exhaust other possibilities first , and if I make no headway, may have to come back to this.

RE: How to check for duplicates on current business object

Ger Cannoll — Mon, 25 Jul 2011 14:50:12 GMT

Hi Ivan. I am not seeing this. Maybe an example might clarify.

Say in the BO . I have following:

[quote]IRELAND
UK
USA
JAPAN
CHINA
IRELAND
FRANCE
BELGIUM
CHINA[/quote]

I want the duplicates in this (So that I can display an error message , as there should not be any duplicates) . So I want returned:-

[quote]IRELAND
CHINA [/quote]

(If I was doing this in Sql, I would use a Select Country ,Count(Country) as MyCount from Mytable Group by Country (And anywhere MyCount > 1 are the duplicates)

RE: How to check for duplicates on current business object

Ivan George Borges — Mon, 25 Jul 2011 13:01:16 GMT

Did you read Paul's post? Or maybe I am misunderstanding what you are looking for.

[codesnippet]MyBO.CopyDataFrom(MyOtherBO.CurrentDataTable.DefaultView.ToTable(True, New String() {"DistictColumn-ColumnName"}), MicroFour.StrataFrame.Business.BusinessCloneDataType.ClearAndFillFromCompleteTable)[/codesnippet]

This should copy only "distinct" rows from MyOtherBO to MyBO, based on the "DistinctColumn-ColumnName".

RE: How to check for duplicates on current business object

Ger Cannoll — Mon, 25 Jul 2011 11:13:46 GMT

Hi Ivan. Thanks for replying.

I have had a look at the thread and the CopydataFrom method but cannot see any option to copy 'Just' duplicated records, or insert a 'Group By' statement. An example of a CopyDataFrom to copy duplicated records only would be very helpful

RE: How to check for duplicates on current business object

Michel Levy — Mon, 25 Jul 2011 10:37:26 GMT

Hi Gerard,

I use QueryAdataset for that purpose (locally querying data in a BO in T-SQL). You'll find it here http://www.queryadataset.com/

RE: How to check for duplicates on current business object

Ivan George Borges — Mon, 25 Jul 2011 10:01:27 GMT

See if this one helps:

http://forum.strataframe.net/FindPost20253.aspx