Click here to Skip to main content
15,897,891 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionVideo encoder library Pin
DenisSavenkov8-Jan-08 13:00
DenisSavenkov8-Jan-08 13:00 
GeneralRe: Video encoder library Pin
Paul Conrad26-Jan-08 7:23
professionalPaul Conrad26-Jan-08 7:23 
GeneralRe: Video encoder library Pin
DenisSavenkov26-Jan-08 9:50
DenisSavenkov26-Jan-08 9:50 
QuestionWebRequest or ??? Pin
#realJSOP8-Jan-08 8:49
professional#realJSOP8-Jan-08 8:49 
AnswerRe: WebRequest or ??? Pin
Patrick Etc.8-Jan-08 12:08
Patrick Etc.8-Jan-08 12:08 
Questionsource of the event log associated to a windows service Pin
Mohammed El-Afifi8-Jan-08 1:11
professionalMohammed El-Afifi8-Jan-08 1:11 
GeneralRe: source of the event log associated to a windows service Pin
led mike8-Jan-08 6:47
led mike8-Jan-08 6:47 
AnswerQuickest/Best way to get lots of data into SQL/Acess etc... Pin
DrTip7-Jan-08 22:31
DrTip7-Jan-08 22:31 
I have been playing around with this for some time and I can't get an elegant solution. My code always looks like I am missing some obvious library.

We have a lot of old fortran code lying about doing Numerical Simulations. I am trying to get some movement into a sensible coding environment. It is becoming prohibitive using Fortran since the skill set (across our company) is diminishing and therefore becoming expensive.

Step one:
Recompile code using the SilverFrost compiler using the .NET options.

Step two:
Call Fortran code from C#.

Step Three:
Start putting result from Fortran into a biggish Sql say 5GB per model run od so


I have got something sensible for steps 1 and 2 and general movement is going in the write direction, step 3 seem to be convoluted.Confused | :confused:

say I have 1 dimenesional array of doubles, I simply want to record in the DB

something like

Index,Answer
0,0.1
1,0.2
2,0.3
3,0.4
4,0.5
5,0.6
6,0.7
7,0.9

currently the Fortran just writes CSV files in the above format.

We could bulk copy the CSV files into the DB but seems like an unnessary step (the CSV file), why not direct?.

We could convert the Arrays into DataTables and use SqlBulkCopy,
( just making the DataTable seems inelegant )

We could write a custom IDataReader for arrays and use SqlBulkCopy,
(Idatareaders seems to require an enormous amount of unsued methods to implemnt)

SqlBulkCopy is not an option for things like Access though or SqlCe if we wanted to use a similar methodolgy for smaller localised models

So the question is whats the "best" way of getting a large .net array into SqlCe,SQL and Access datbases.

I guess thats 3 questions one for each format

Carl

DrTip
GeneralRe: Quickest/Best way to get lots of data into SQL/Acess etc... Pin
Dave Kreskowiak10-Jan-08 8:53
mveDave Kreskowiak10-Jan-08 8:53 
GeneralRe: Quickest/Best way to get lots of data into SQL/Acess etc... Pin
DrTip10-Jan-08 10:04
DrTip10-Jan-08 10:04 
GeneralRe: Quickest/Best way to get lots of data into SQL/Acess etc... [modified] Pin
Dave Kreskowiak10-Jan-08 10:11
mveDave Kreskowiak10-Jan-08 10:11 
GeneralRunning .NET applications on Vista without admin privileges [modified] Pin
Patrick Etc.7-Jan-08 9:51
Patrick Etc.7-Jan-08 9:51 
GeneralRe: Running .NET applications on Vista without admin privileges Pin
Mark Salsbery7-Jan-08 10:25
Mark Salsbery7-Jan-08 10:25 
GeneralRe: Running .NET applications on Vista without admin privileges Pin
Patrick Etc.7-Jan-08 11:13
Patrick Etc.7-Jan-08 11:13 
GeneralRe: Running .NET applications on Vista without admin privileges Pin
Mike Dimmick7-Jan-08 11:17
Mike Dimmick7-Jan-08 11:17 
GeneralRe: Running .NET applications on Vista without admin privileges Pin
Patrick Etc.8-Jan-08 8:08
Patrick Etc.8-Jan-08 8:08 
QuestionUse of .Net 2.0 class in MSVS 2003 project Pin
boemie7-Jan-08 4:36
boemie7-Jan-08 4:36 
GeneralRe: Use of .Net 2.0 class in MSVS 2003 project Pin
Luc Pattyn7-Jan-08 6:44
sitebuilderLuc Pattyn7-Jan-08 6:44 
GeneralRe: Use of .Net 2.0 class in MSVS 2003 project Pin
boemie7-Jan-08 19:49
boemie7-Jan-08 19:49 
GeneralApplication/Configuration Data Pin
Dave Moor (the real one)7-Jan-08 4:21
Dave Moor (the real one)7-Jan-08 4:21 
GeneralRe: Application/Configuration Data Pin
Mark Salsbery7-Jan-08 9:38
Mark Salsbery7-Jan-08 9:38 
GeneralBackward Compatibility in Visual Studio .NET 2003 Pin
Ashraf Tirawi6-Jan-08 23:40
Ashraf Tirawi6-Jan-08 23:40 
QuestionHow to copy a reference type ? Pin
devboycpp6-Jan-08 21:15
devboycpp6-Jan-08 21:15 
AnswerRe: How to copy a reference type ? Pin
Urs Enzler7-Jan-08 3:08
Urs Enzler7-Jan-08 3:08 
GeneralThreading in c# Pin
Prabhat0036-Jan-08 17:36
Prabhat0036-Jan-08 17:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.