This Job is composed by two part :
1) SQL Table loader (around 5 Mil rows) into Dictionary
2) Possibility to share Dictionary Object between different processes.
I have a SQL Table with around 40 columns (float, nvarchar, date) with 5 Million record. I would like to load these column into my C# application (Dictionary) in fastest way you know. Currently I'm able to get these data in around 90 seconds using multithread solution and SQL Paging. I need a solution less or equal 30 sec.
The Dictionary is made in this way : Dictionary<int, TableClass> where int is the SQL Table ID and TableClass is a Class with all SQL Table Fields.
I have a C# Desktop Application that use a Dictionary that contains around 3 Mil. items. I would like to have the possibility to get a particular item (using LINQ for example) from a different C# Desktop application.
.NET Framework 4.5, C#, 64bit