Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles
 
(untagged)

HyperNetDatabase

0.00/5 (No votes)
21 Mar 2004 1  
HyperNetDatabase is a single process multithreading and blackout safe database

Sample Image - maximum width is 600 pixels

Sample Image - maximum width is 600 pixels

Introduction

This project was developed in order to help users that use databases like commercial ACCESS for small projects and then are subject to commercial laws. This is a simple solution for a database engine that can supply a good power to normal database tasks. This driver is free (GPL).

Using the code

Link the two DLLs HyperNetDatabase.DLL and NetFrmExts.DLL to your project and you'll be linked. Note use R2 Only, R1 is older and unstable.

To open a database and make a select: 

using HyperNetDatabase.R2;
...
Database db = new Database();
db.Open("file.hnd"); // creates or opens database

...
..
DataTable result = db.Select(
    new string[]{"SEQNAME"}, // fields as an array of strings

    "$Sequences", // Name of the table

    new object[,]{ {"SEQNAME","=",myseq} } 
  // pairs of filter conditions : ... WHERE SEQNAME=myseq AND ...

    );
..
db.Close();

 

Public Static Methods


DataRow2NameAndValue Converts a DataRow in a NameAndValue object with skipRows.

Public Instance Constructors


Database Constructor Default constructor

Public Instance Properties


Filename Filename of the database
"MlVlHyperNetDatabase/pubproperty.gif">Lock Global lock, used to lock other thread to make concurrent queries. Example: Read and then insert.
"MlVlHyperNetDatabase/pubproperty.gif">State Connection state

Public Instance Methods

"MlVlHyperNetDatabase/pubmethod.gif">AddField Adds a field
"MlVlHyperNetDatabase/pubmethod.gif">AddFieldIfNotExist Adds a field if it not exists
"MlVlHyperNetDatabase/pubmethod.gif">AddTable Adds a table
"MlVlHyperNetDatabase/pubmethod.gif">AddTableIfNotExist Adds a table if it not exists
"MlVlHyperNetDatabase/pubmethod.gif">Close Closes a database
"MlVlHyperNetDatabase/pubmethod.gif">Delete SQL DELETE query Example: 
   using HyperNetDatabase.R2;
   ...
   Database db = new Database();
   db.Open("file.hnd"); 
    // creates or opens database

   ...
   string StockName = "peppers";
   DataTable result = db.Delete("Stock",
   new object[,]{ {"NAME","=",StockName} }
   );
   ...

Is the same as: DELETE Stock WHERE NAME=@StockName

WHERE expression: Is an C# expresion for making a where as a filter.

  • new object[,]{ {"{FIELDNAME}",{operand},{parameter}},... } Is the same as "field operand parameter AND ..."
  • null Means the same as no where condition.

Operand Effect
= Equality
> Value of left field name is greater than right constant value variable
>= Value of left field name is greater or equal than right constant value variable
< Value of left field name is less than right constant value variable
<= Value of left field name is less or equal than right constant value variable
!= Value of left field name is different than right constant value variable

"MlVlHyperNetDatabase/pubmethod.gif">DropTable Removes a table
"MlVlHyperNetDatabase/pubmethod.gif">DropTableIfExists Drops a table if the table exists
"MlVlHyperNetDatabase/pubmethod.gif">Dump Dumps pages state
"MlVlHyperNetDatabase/pubmethod.gif">ExistsTable Returns true if the table exists
"MlVlHyperNetDatabase/pubmethod.gif">FlushIndexes Destroys in memory indexes. Do this if your were walking for many tables and you memory resources are low.
"MlVlHyperNetDatabase/pubmethod.gif">ForcedInsert Overloaded. More known as Update or Insert (Sets values by a keyfield) Inserts if the condition does not match or updates if the condition matches.
   db.ForcedInsert( "Stock", "NAME", 
     "Peppers", "Qty", 0.5m );
Is the same as: 
   SELECT Count(*) FROM STOCK WHERE NAME="Peppers";
   if count > 0 then
   UPDATE STOCK SET Qty=0.5 WHERE NAME="Peppers";
   else
   INSERT INTO STOCK (NAME,Qty) 
      VALUES ("Peppers",0.5);
"MlVlHyperNetDatabase/pubmethod.gif">ForcedSelect Obtains a value and if it not exists obtains it's default value
"MlVlHyperNetDatabase/pubmethod.gif">GetTableNames Gets all tables in this database
"MlVlHyperNetDatabase/pubmethod.gif">GetUserFields Fields for users
"MlVlHyperNetDatabase/pubmethod.gif">Insert Inserts data into a Table Example: 
   using HyperNetDatabase.R2;
   ...
   Database db = new Database();
   db.Open("file.hnd"); 
    // creates or opens database

   ...
   string StockName = "peppers";
   DataTable result = db.Insert(
    "Stock", new object[,]
  { {"NAME",StockName}, {"QTY",0.5m} } );
   ...

Is the same as: INSERT INTO Stock (NAME,QTY) VALUES (@StockName,0.5);

SET expression: Is an C# expresion for indicate a FIELD with its VALUE.new object[,]{ {"{FIELDNAME}",{parameter}},... } Is the same as "SET field = parameter, ..."Example 1: 

     new object[,]{ {"QTY",0.5m} }
Example 2: 
     new object[,]{ {"STRNAME","peppers"}, 
      {"QTY",0.5m} }
LogToFile (inherited from LogSupport) Saves a string in the log file
"MlVlHyperNetDatabase/pubmethod.gif">Open Open
"MlVlHyperNetDatabase/pubmethod.gif">PreloadIndexes Preloads indexes for table to make reads faster
"MlVlHyperNetDatabase/pubmethod.gif">Select SQL Select query. Example: 
   using HyperNetDatabase.R2;
   ...
   Database db = new Database();
   db.Open("file.hnd"); // creates or opens database

   ...
   string StockName = "peppers";
   DataTable result = db.Select(null,"Stock",
   new object[,]{ {"NAME","=",StockName} }
   );
   ...
   result = db.Select(new string[]{"NAME"},"Stock",
   new object[,]{ {"NAME","=",StockName} }
   );
   ...
Is the same as:
  • SELECT * FROM Stock WHERE NAME=@StockName
  • SELECT NAME FROM Stock WHERE NAME=@StockName
WHERE expression: Is an C# expresion for making a where as a filter.
  • new object[,]{ {"{FIELDNAME}", {operand},{parameter}},... } Is the same as "field operand parameter AND ..."
  • null Means the same as no where condition.

Operand Effect
= Equality
> Value of left field name is greater than right constant value variable
>= Value of left field name is greater or equal than right constant value variable
< Value of left field name is less than right constant value variable
<= Value of left field name is less or equal than right constant value variable
!= Value of left field name is different than right constant value variable

"MlVlHyperNetDatabase/pubmethod.gif">seqCreate Overloaded. Creates a sequence.
"MlVlHyperNetDatabase/pubmethod.gif">seqCurrentValue Current sequence value
"MlVlHyperNetDatabase/pubmethod.gif">seqDrop Sequence drop
"MlVlHyperNetDatabase/pubmethod.gif">seqExists Sequence exists?
"MlVlHyperNetDatabase/pubmethod.gif">seqNextValue Next sequence value (and autoincrement)
"MlVlHyperNetDatabase/pubmethod.gif">Update SQL UPDATE query Example: 
   using HyperNetDatabase.R2;
   ...
   Database db = new Database();
   db.Open("file.hnd"); // creates or opens database

   ...
   string StockName = "peppers";
   DataTable result = db.Update("Stock",
   new object[,]{ {"NAME",StockName}, {"QTY",0.5m} },
   new object[,]{ {"NAME","=","pepperoni"} }
   );
   ...

Is the same as: UPDATE Stock SET NAME=@StockName, QTY=0.5 WHERE NAME=pepperoni

WHERE expression: Is an C# expresion for making a where as a filter.

  • new object[,]{ {"{FIELDNAME}",{operand},{parameter}},... } Is the same as "field operand parameter AND ..."
  • null Means the same as no where condition.

Operand Effect
= Equality
> Value of left field name is greater than right constant value variable
>= Value of left field name is greater or equal than right constant value variable
< Value of left field name is less than right constant value variable
<= Value of left field name is less or equal than right constant value variable
!= Value of left field name is different than right constant value variable

SET expression: Is an C# expresion for indicate a FIELD with its VALUE.

new object[,]{ {"{FIELDNAME}",{parameter}},... } is the same as "SET field = parameter, ..."

Example 1: 

     new object[,]{ {"QTY",0.5m} }
Example 2: 
     new object[,]{ {"STRNAME","peppers"}, 
      {"QTY",0.5m} }



Points of Interest

  • Support all SQL basic functions.
  • Additional features.
  • Protect from Blackouts
  • Multithreading-safe

History

RELEASE VERSION 2.0.0 NOTES - 2004-03-17

Features:

  • First stable version
  • Support all SQL basic functions.
  • Additional features.
  • Protect from Blackouts
  • Multithreading-safe

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here



Permalink

Privacy
Cookies
Terms of Use
Layout: fixed | fluid

Article Copyright 2004 by M L Vi�as Livschitz
Everything else Copyright © CodeProject, 1999-2024

Web01 2.8:2024-10-20:1