Database

insert into mytesttable (MyDateField) values (getdate())

CREATE TABLE [MyTestTable] (
    [IDColumn] [int] IDENTITY (1, 1) NOT NULL ,
    [DateCreated] AS (getdate())
) ON [PRIMARY]

Skanless wrote:

1. If you are new to a database, is there a way that you can quickly find out relationships between the tables?

Skanless wrote:

2. I need to retrieve information on all the tables in a database to find out which tables have a rowcount of more than 50,000 records then delete some record which thus reducing the table to 50,000 rows so as to make space. Is there a way to do that? and if so, what is the syntax to obtain this?

Skanless wrote:

3. How can I cascade constraints when deleting records from a specific table?

DataTable DT = new DataTable();
if(m_DB is SqlConnection)
{
	m_DA = new SqlDataAdapter(Query,(SqlConnection)m_DB);
	m_CB = new SqlCommandBuilder((SqlDataAdapter)m_DA);
	((SqlCommandBuilder)m_CB).QuotePrefix="[";
	((SqlCommandBuilder)m_CB).QuoteSuffix="]";
	((SqlDataAdapter)m_DA).Fill(DT);
}

SELECT Max(ProductID) FROM Product

UI->App Layer|->ObjectAList|->  ObjectClassA  |->clsDatabase|->ADO.NET|->DB1
             |
             |->ObjectBList|->  ObjectClassB  |->clsDatabase|->ADO.NET|->DB1

using Project1;
using Project2;

clsProject1List prjList1;
clsProject2List prjList2;
clsProject1.clsDatabase mDatabase1;
clsProject2.clsDatabase mDatabase2;

public clsMediator()
{
    string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data           
                               Source=mydatabase.mdb;";
    string dataProvider = "OLEDB";
    mDatabase1 = new clsDatabase(connectionString, dataProvider);
    mDatabase2 = new clsDatabase(connectionString, dataProvider);
}

UI->App Logic |>ObjectAList|>ObjectA|
              |                     |>clsDatabase->ADO.NET->Database
              |>ObjectBList|>ObjectB|