Posted: 9/30/2010
Hello Experts,
I was reading about Datatable in ADO.NET and I have read a line but didn't get the meaning.
Line - DataTable represents one table of in-memory relational data.
Can anyone tell me what is meaning of in-memory relational data?
Thanks in advance.
mohit said: user="mohit kumar"]Can anyone tell me what is meaning of in-memory relational data?
user="mohit kumar"]Can anyone tell me what is meaning of in-memory relational data?
See: http://en.wikipedia.org/wiki/In-memory_database
Here are my two cents to clarify things out:
DataTables are used in .NET development to temporarily (which means in-memory) hold data as needed. Think of them as the results of a sql query against a database; they are roughly similar to CSV files or other forms of tabular data in which you can pull data into them from a database, work with the data, and then push the changes back to a database.
In other words, it provides developer a temporary cache to store data in memory and to work on data in a disconnected manner. Once your data is available in DataSet/DataTable, It can be used without ever connecting to a database.