Hey Phil,
Seems pretty clean to me, if you want to clean this up into a assert then
I'd welcome the contribution.
Andy
On 12/12/06, Phil Winstanley <[EMAIL PROTECTED]> wrote:
>
>
>
> Guys,
>
>
>
> I'm not sure if I'm going about this the right way, but I found myself
> testing complex processing stored procedures in SQL and I had a need for an
> AssertExecuteScalar.
>
>
>
> So I wrote one … ish.
>
>
>
> What are your thoughts?
>
>
>
> * [*Test*()]*
>
> * *public* *void* Import()*
>
> * {*
>
>
>
> * *string* SQL = (*@"INSERT INTO TestingTable
>
> SELECT *
>
> FROM SampleData"*);*
>
> * ExecuteSQL(SQL);*
>
>
>
> * SQL = (*"EXEC ComplexSQL"*);*
>
> * ExecuteSQL(SQL);*
>
>
>
> * SQL = (*"SELECT Count(*) From OtherTestingTable"*);*
>
> * *int* Count = *Convert.ToInt32(ExecuteScalar(SQL));
>
>
>
> * AssertScalar(SQL, 3);*
>
>
>
> * }*
>
>
>
> * *private* *void* AssertScalar(*string* SQL, *object* ExpectedValue)*
>
> * {*
>
> * *object* o = ExecuteScalar(SQL);*
>
> * *Assert.AreEqual(ExpectedValue, o);
>
> * }*
>
>
>
> * *private* *object* ExecuteScalar(*string* SQL)*
>
> * {*
>
> * *using* (*SqlConnection* Conn = *new* *SqlConnection*
> (_ConnectionString))*
>
> * *using* (*SqlCommand* Comm = *new* *SqlCommand*(SQL, Conn))*
>
> * {*
>
> * Conn.Open();*
>
> * *return* Comm.ExecuteScalar();*
>
> * }*
>
> * }*
>
>
>
>
>
> Cheers,
>
>
>
> Phil.
>
>
>
>
>
> ------------------------------------------------------------------------
>
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they are
> addressed.
>
> If you have received this email in error please notify the originator of
> the message. This footer also confirms that this email message has been
> scanned for the presence of computer viruses, though it is not
> guaranteed virus free.
>
> Original Recipient: [email protected]
> Original Sender : [EMAIL PROTECTED]
> Original Send Date: 12/12/2006 - 14:52:01
>
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"MbUnit.User" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/MbUnitUser?hl=en
-~----------~----~----~----~------~----~------~--~---
