Comments by Sni.DelWoods (Top 36 by date)

If this occurs in a WPF desktop an: Did you use a dispatcher (=> google) otherwise the textbox is updated in a new instance, not in the screen...

Actually none. :-) The default behaviour would be mapping to a table named DateTimeRange and ends in an error, because there is no Id property in the DateTimeRange model.

Please rewrite the VB code in a readable form to make clear what it does, e.g.
Dim gCurrentX = AddressOf Me.gCurrentX 'Why do you need AdressOf here??
Dim gCurrentY = Me.gCurrentW
Dim numRef As Integer = CInt(gCurretX)
..

I understand the multiple C# converions, VB returns a double on Int * Double, C# returns Int.
After that you should have one removed most of the conversions in the VB code. After that you can convert it to C#..

Thanks for your post Maciej. I know how the provided notifier works, but as mentioned that's not the pattern I wanted to use. I was looking for something that works without using the property setter. In my specific case my solution is good enough.

The static constructor does not have parameters. I just want to add a very basic license key to implement a very simple solution to avoid that other people use my dll libary in their own project. So setting a simple fixed password is enough. A simple license key file which is loaded in the construtor would not solve the problem as the file could easily be copied.

The lib is very interessting, but this is too over the top for my problem.

This could work, but I don't think thats the best solution. In a non-static class I would have the key integrated in the constructor and checked it once at creating the instance. e.g. var licence = new Licence("ABC123");
In the static class I have actually no idea how to implement this.

You are absolutly right. I've added the reason to my question, so maybe there is a better solution for the problem.

Yes, that's what I detected. But why can't I use a lambda ()=>method.
I would have expected there's no difference between my Task.Run and the Threading.Tasks.Task.Run.
(Just want to understand what's happening here...Some things won't get in my mind...)

Great, this works. Thank you!

By the way:
Why do I have use the method directly instead of using a lambda?
As I can see the .net method has the same signature: Run (Action action)

And why do I HAVE to use a lambda if my method uses parameters?

 public static void DummyTask(string param) {...}

 TestHelpers.Tasks.Run(() => TestTasks.CustomTasks.DummyTask("My parameter"));

Seems that LINQ has absolutly no optimization on performance.
I would have exptected that LINQ is a bit slower on large, complex objects but not on a simple string array.

Nevermind, good to know so I'm building an extension method for that case.
Thanks.

AddRange() does not slow down the process, it's the LINQ expression.

That's a very good information in general.
So all code of a class exits only one time in the whole project.

I learned that no mather how many code is in the class only variables are instanced - in the example it is only workerCount.

Thank for that.

Thanks for your comment.

Thanks for that. The Microsoft way of filetable is very .....poor. Would have been to easy to link just a table field to a file or something like that.

The code solution apart from the sql server seems indeed to be the best solution.

A filewatcher is what I already have. Application checks the directory and Updates the database.

Depends on which data you have and what you want to do with that data.

I implemented a non-generic data lake as a separate sql database with multiple tables, all fields as nvarchar.

The data I get has a fixed structure. So I import the data from CSV files to the table (rawlist1.csv to table [rawlist]).
The CSV comes every day with a growing number of lines. The productive table gets only the new rows. So I import all lines to the data lake table and copy only the new rows to the productive table.

This helps to keep the productive table clear from obsolete data. The data lake table keeps only data from the last 10 days.

Thanks. Could you give me a short code snippet how to do this asynchronously?
I tried the script on a new website, without web.config or any other configurations. I have the same result.

...just to finish the Code..
Using the Log in a generic class (class Import, class Statistic...):

public void Test()
{
    var managerGeneral = new Manager<LogGeneral>();
    // Manager can do the work which has to be logged in the specific log type.
}

public class Manager<T> where T:LogBase   
{        
    public T Log = (T)Activator.CreateInstance(typeof(T));    
}

That's the definition I was looking for:
public class Log : List<entrybase> {}

The code was not complete and just an example.
By writing the question I figured out it's a better way for me to use the Log as base class:

public abstract class LogBase() {}
public class ImportLog : LogBase() {
var entries = new list<importentry>();
//...
}

Thank you anyway for the solution.

I found a very good nested class solutions, where I don't have to care about the references. See solution below. Thanks.

That the base idea.
I already split the class into a partial class and different files (MyBigClass.DataAccess.vb)

But how can I access the myData-object in MyBigClass frm the DataAccess class?
I added an example of my current solution. I think there should be a bettern pattern to to this....

Thanks for the reply.
I created a emtpy website project with the code above.
Default language for the project is vb.

In the object browser I can see that the two classes have different namespaces.
I have really no idea why I can call vb from c# but not the other way.

There is no using in the cs-class which can use the vb-class.
And I can't use "import i4d-mcco" in the vb-class.

Entries in the object browser:

public class csClass
Member of App_SubCode_cs.i4d-mcco

public class vbClass
Member of App_SubCode_vb.h1___n28

Public Class vbClass
Inherits Object
Member of App_SubCode_vb.h1___n28

I created a emtpy website project with the code above.
Default language for the project is vb.

In the object browser I can see that the two classes have different namespaces.
I have really no idea why I can call vb from c# but not the other way.

Would be great if someone could reproduce that problem.

See my comment above. In short:

It's a 1:n self join link.
article1 has 3 rows with 3 keywords:
artNo 1, keyword1
artNo 1, keyword2
artNo 1, keyword3

Other articles may have the same top 3 keywords or not.
I need all articles which have the same 3 keywords (=3 rows with same keyword as article1)

Hope this was better....:-)

Let me extend my problem:
I'm building a keyword index of serveral items (fields: itemNo, keyword, code). Code is a calculated (phonetical) field to mark same keywords (e.g. thomaz [268]= thomas [268]).

The number of keyword per item is different. To find similar items I want to compare the first 2 (or 5 or 10) keywords of the first item with the first 2 (or 5 or 10) items of the second item. The keywords are sorted.

So if item 1 has the TOP 2 keywords aaa,bbb all other items are simlilar if they also have the TOP 2 keywords aaa, bbb. Items which have the TOP 2 keywords bbb,ccc are not similar and should not be returned by the select query.

This is meant by
(SELECT TOP 2 code FROM Table WHERE item=1 ORDER BY code) = (SELECT TOP 2 code FROM Table WHERE item<>1 ORDER BY code)

left(code,2) is not top(2)

thx. actually it's Access.

Maybe it's the better approach if you use some Firefox plugins to perform a website test.

I solved this problem by using javascript which opens serveral links to a download script.

sub Download
response.write("<script language='javascript'>")
response.write("newwindow('download.aspx?action=filename1');")
response.write("newwindow('download.aspx?action=filename2');")
response.write("</script>")
end sub

You could also add session-variables:
session("file-content1")=strContent1
session("file-content2")=strContent2

download: response.write(session("file-content1").tostring)

This is just useable if the target system has no poup blocker or something.
There is also a solution using iFrames (search).
Actually I'm using ZIP files most the time.

regards,
Andi