locked
How to solve this Problem in reality Topic : File as Database RRS feed

  • Question

  • Hello Msdns

    I have Small requirement in my current project ,

    I have a C# application which is may be to process some information and store the data in System.DataTable in Memory  

    But i have requirement to store this in Database ( currently we dont have Database infrastructure )  is there any  way to use a file based as DataBase for example just  like .*MDF in shared drive is its possible to use the application in every system which is connected to Network drive  

    for few months we will have Database but for the time being is it any way to slove this in File based DB 

    I want to store the information from different network devices.

    Thanks

    Ranjith  

     


    Ranjith@Learner @Microsoft products

    Monday, June 6, 2016 3:22 PM

Answers

  • Hi Ranjith,

    >>"i want to know is it possible to use Sql lite in network drive ? "

    The short answer is yes. But it can not be used simultaneously. Here is the description from SQLite official site.

    "If there are many client programs sending SQL to the same database over a network, then use a client/server database engine instead of SQLite.  SQLite will work over a network filesystem, but because of the latency associated with most network filesystems, performance will not be great."

    >>"i want deployment so how the Database in Centrallized location like network drive at the moment "

    If the database will be used by multi clients? If yes, please don't use SQLite or any other local batabase. You could choose server based database.

    Best Regards,
    Li Wang


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    • Edited by DotNet Wang Wednesday, June 8, 2016 3:24 AM
    • Proposed as answer by Konrad Neitzel Wednesday, June 8, 2016 4:33 AM
    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:33 AM
    Wednesday, June 8, 2016 3:22 AM
  • I would use SQLite

    https://www.sqlite.org/

    You will need the ADO.NET provider as well.

    https://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki


    william xifaras

    • Proposed as answer by William Xifaras Monday, June 6, 2016 5:34 PM
    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:32 AM
    Monday, June 6, 2016 5:34 PM
  • On initial stages, before having the required database infrastructure and supporting multiple clients, consider files which can be manipulated with DataTable.WriteXml and DataTable.ReadXml.


    • Edited by Viorel_MVP Monday, June 6, 2016 5:49 PM
    • Proposed as answer by DotNet Wang Wednesday, June 8, 2016 3:27 AM
    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:32 AM
    Monday, June 6, 2016 5:49 PM
  • SQL is your best option as it will facilitate  you moving towards a real database in the future. So NO, there is no disadvantage in using it. Its a fairly standard technology now for this type of thing.

    william xifaras

    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:33 AM
    Wednesday, June 8, 2016 2:53 PM

All replies

  • I would use SQLite

    https://www.sqlite.org/

    You will need the ADO.NET provider as well.

    https://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki


    william xifaras

    • Proposed as answer by William Xifaras Monday, June 6, 2016 5:34 PM
    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:32 AM
    Monday, June 6, 2016 5:34 PM
  • On initial stages, before having the required database infrastructure and supporting multiple clients, consider files which can be manipulated with DataTable.WriteXml and DataTable.ReadXml.


    • Edited by Viorel_MVP Monday, June 6, 2016 5:49 PM
    • Proposed as answer by DotNet Wang Wednesday, June 8, 2016 3:27 AM
    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:32 AM
    Monday, June 6, 2016 5:49 PM
  • I have small question how about Sql Lite file in Shared Drive so that its available for every one ? 

    Ranjith@Learner @Microsoft products

    Tuesday, June 7, 2016 9:19 PM
  • I am using Xml as of now , is there any big advantage against Sql Lite ?

    Ranjith@Learner @Microsoft products

    Tuesday, June 7, 2016 9:20 PM
  • hello i want to know is it possible to use Sql lite in network drive ? 

    Please let me know any alterntive i dont have Database in department so i want deployment so how the Database in Centrallized location like network drive at the moment i am using Xml file please let me know any alternative way 


    Ranjith@Learner @Microsoft products

    • Merged by DotNet Wang Tuesday, June 14, 2016 9:51 AM similar question
    Tuesday, June 7, 2016 9:22 PM
  • Hi Ranjith,

    >>"i want to know is it possible to use Sql lite in network drive ? "

    The short answer is yes. But it can not be used simultaneously. Here is the description from SQLite official site.

    "If there are many client programs sending SQL to the same database over a network, then use a client/server database engine instead of SQLite.  SQLite will work over a network filesystem, but because of the latency associated with most network filesystems, performance will not be great."

    >>"i want deployment so how the Database in Centrallized location like network drive at the moment "

    If the database will be used by multi clients? If yes, please don't use SQLite or any other local batabase. You could choose server based database.

    Best Regards,
    Li Wang


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    • Edited by DotNet Wang Wednesday, June 8, 2016 3:24 AM
    • Proposed as answer by Konrad Neitzel Wednesday, June 8, 2016 4:33 AM
    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:33 AM
    Wednesday, June 8, 2016 3:22 AM
  • SQL is your best option as it will facilitate  you moving towards a real database in the future. So NO, there is no disadvantage in using it. Its a fairly standard technology now for this type of thing.

    william xifaras

    • Marked as answer by DotNet Wang Wednesday, June 15, 2016 1:33 AM
    Wednesday, June 8, 2016 2:53 PM
  • Technically you can put on a share.

    "Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time."

    Read section 5

    https://www.sqlite.org/faq.html


    william xifaras

    Wednesday, June 8, 2016 2:56 PM