//this is the xml added replace here your log4net and Nunit paths //<Reference Include="log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=1b44e1d426115821, processorArchitecture=MSIL"> // <SpecificVersion>False</SpecificVersion> // <HintPath>..\..\..\Log4Net\log4net-1.2.10\bin\net\2.0\release\log4net.dll</HintPath> //</Reference> //<Reference Include="nunit.framework, Version=2.4.8.0, Culture=neutral, PublicKeyToken=96d09a1eb7f44a77, processorArchitecture=MSIL" /> using System; using System.Collections.Generic; using System.Linq; using System.Text; using log4net; using log4net.Config; using NUnit.Framework; namespace ExampleConsoleApplication { [TestFixture] class TestClass { private static readonly ILog logger = LogManager.GetLogger ( typeof ( TestClass ) ); static void Main ( string[] args ) { Console.WriteLine ( " START " ); #region LoggerUsage DOMConfigurator.Configure (); //tis configures the logger logger.Debug ( "Here is a debug log." ); logger.Info ( "... and an Info log." ); logger.Warn ( "... and a warning." ); logger.Error ( "... and an error." ); logger.Fatal ( "... and a fatal error." ); #endregion LoggerUsage TestClass objTestClass = new TestClass(); objTestClass.TestMethodNameOK (); objTestClass.TestMethodNameNOK (); Console.WriteLine ( " END HIT A KEY TO EXIT " ); Console.ReadLine (); } //eof method [SetUp] protected void SetUp () { //Add Here the Initialization of the objects } [Test ( Description = "Add here the description of this test method " )] protected void TestMethodNameOK () { //build ok use case scenario here - e.g. no exception should be raced ' //Vegetable newCarrot = pool.GetItemByPropertyValue<Vegetable> ( "WriongByPurpose", "Orange" ); //Assert.IsInstanceOfType ( typeof ( Vegetable ), newCarrot ); //Assert.AreSame ( newCarrot, carrot ); //logger.Info ( " I got the newCarrot which is " + newCarrot.Color ); } //eof method [Test ( Description = "Add here the description of this test method " )] protected void TestMethodNameNOK () //e.g. the one that should raze Exception { //build ok use case scenario here - e.g. no exception should be raced ' //Vegetable newCarrot = pool.GetItemByPropertyValue<Vegetable> ( "WriongByPurpose", "Orange" ); //Assert.IsInstanceOfType ( typeof ( Vegetable ), newCarrot ); //Assert.AreSame ( newCarrot, carrot ); //logger.Info ( " I got the newCarrot which is " + newCarrot.Color ); } //eof method } //eof class } //eof namespace //click inside , Ctrl + M , M to collapse - copy paste you own code namespace ClassesToTest { class ClassToTest { //this is the name of the method to test public void MethodName ( string param ) { } } //eof class } //eof class #region TheAppConfig /* <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" /> </configSections> <log4net> <appender name="LogFileAppender" type="log4net.Appender.FileAppender"> <param name="File" value="LogTest2.txt" /> <param name="AppendToFile" value="true" /> <layout type="log4net.Layout.PatternLayout"> <param name="Header" value="[Header] \r\n" /> <param name="Footer" value="[Footer] \r\n" /> <param name="ConversionPattern" value="%d [%t] %-5p %c %m%n" /> </layout> </appender> <appender name="ColoredConsoleAppender" type="log4net.Appender.ColoredConsoleAppender"> <mapping> <level value="ERROR" /> <foreColor value="White" /> <backColor value="Red, HighIntensity" /> </mapping> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" /> </layout> </appender> <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.2.10.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <connectionString value="data source=ysg;initial catalog=DBGA_DEV;integrated security=true;persist security info=True;" /> <commandText value="INSERT INTO [DBGA_DEV].[ga].[tb_Data_Log] ([Date],[Thread],[Level],[Logger],[Message]) VALUES (@log_date, @thread, @log_level, @logger, @message)" /> <parameter> <parameterName value="@log_date" /> <dbType value="DateTime" /> <layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" /> </parameter> <parameter> <parameterName value="@thread" /> <dbType value="String" /> <size value="255" /> <layout type="log4net.Layout.PatternLayout" value="%thread" /> </parameter> <parameter> <parameterName value="@log_level" /> <dbType value="String" /> <size value="50" /> <layout type="log4net.Layout.PatternLayout" value="%level" /> </parameter> <parameter> <parameterName value="@logger" /> <dbType value="String" /> <size value="255" /> <layout type="log4net.Layout.PatternLayout" value="%logger" /> </parameter> <parameter> <parameterName value="@message" /> <dbType value="String" /> <size value="4000" /> <layout type="log4net.Layout.PatternLayout" value="%messag2e" /> </parameter> </appender> <root> <level value="INFO" /> <appender-ref ref="LogFileAppender" /> <appender-ref ref="AdoNetAppender" /> <appender-ref ref="ColoredConsoleAppender" /> </root> </log4net> </configuration> */ #endregion TheAppconfig
using System; using System.Collections.Generic; using System.Text; using System.Collections.Specialized; using System.Reflection; using log4net; using log4net.Config; namespace DH { //DH - DataHolders /// <summary> /// This class models a storage structure for objects queriable by id or property name and property value /// </summary> public class ObjectPool { #region Props private int _TotalCount; public int TotalCount { get { return _TotalCount; } } public int ID { get; set; } #endregion Props public ObjectPool () { m_pool = new Dictionary<Type, Dictionary<Int32, Object>> (); } private Dictionary<Type, Dictionary<Int32, Object>> m_pool; public void AddItem<T> ( Int32 pID, T value ) { Type myType = typeof ( T ); if (!m_pool.ContainsKey ( myType )) { m_pool.Add ( myType, new Dictionary<int, object> () ); m_pool[myType].Add ( pID, value ); _TotalCount++; return; } if (!m_pool[myType].ContainsKey ( pID )) { m_pool[myType].Add ( pID, value ); _TotalCount++; return; } m_pool[myType][pID] = value; _TotalCount++; //Utils.Debugger.WriteIf("Adding 1 to pool count , pool count is " + this._TotalCount); } public void AddItem<T> ( T value ) { Int32 pID = _TotalCount; Type myType = typeof ( T ); if (!m_pool.ContainsKey ( myType )) { m_pool.Add ( myType, new Dictionary<int, object> () ); m_pool[myType].Add ( pID, value ); _TotalCount++; return; } if (!m_pool[myType].ContainsKey ( pID )) { m_pool[myType].Add ( pID, value ); _TotalCount++; return; } m_pool[myType][pID] = value; _TotalCount++; //Utils.Debugger.WriteIf("Adding 1 to pool count , pool count is " + this._TotalCount); } public bool RemoveItem<T> ( Int32 pID ) { Type myType = typeof ( T ); if (!m_pool.ContainsKey ( myType )) return false; if (!m_pool[myType].ContainsKey ( pID )) return false; _TotalCount--; return m_pool[myType].Remove ( pID ); } public bool ContainsKey<T> ( Int32 pID ) { Type myType = typeof ( T ); if (!m_pool.ContainsKey ( myType )) return false; if (!m_pool[myType].ContainsKey ( pID )) return false; return m_pool[myType].ContainsKey ( pID ); } /// <summary> /// Gets an IEnumerable collections of objects with Type T /// </summary> /// <typeparam name="T">The type of the items</typeparam> /// <returns>the dictionary of objects</returns> public IEnumerable<T> GetItems<T> () { Type myType = typeof ( T ); if (!m_pool.ContainsKey ( myType )) return new T[0]; return m_pool[myType].Values as IEnumerable<T>; } /// <summary> /// Gets the item. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="pID">The p ID.</param> /// <returns></returns> /// <exception cref="KeyNotFoundException"></exception> public T GetItem<T> ( Int32 pID ) { // will throw KeyNotFoundException if either of the dictionaries // does not hold the required key return (T)m_pool[typeof ( T )][pID]; } /// <summary> /// Returns the first Item from the Collection by it's property name and its value /// </summary> /// <typeparam name="T">The Type of the Object to get </typeparam> /// <param name="strPropMetaName"> the string representation of the </param> /// <param name="strPropValue">the value of the property</param> /// <returns></returns> public T GetItemByPropertyValue<T> ( String strPropMetaName, String strPropValue ) { Type myType = typeof ( T ); for (int i = 0; i < this.TotalCount; i++) { if (!m_pool.ContainsKey ( myType )) { return default ( T ); } else { if (this.ContainsKey<T> ( i )) { //get an item object having the same type T item = this.GetItem<T> ( i ); //if the object has the same property -- check its value MemberInfo[] members = myType.GetMembers (); for (int j = 0; j < members.Length; j++) { //logger.Info ( "members[j].Name is " + members[j].Name ); //logger.Info ( ".MemberType.ToString() " + members[j].MemberType.ToString () ); //logger.Info ( "members[j].GetType().ToString() " + members[j].GetType ().ToString () ); //logger.Info ( " members[j].ToString () is " + members[j].ToString () ); //logger.Info ( " members[j].ToString () is " + members[j] ); if (members[j].Name.ToString ().Equals ( strPropMetaName )) { FieldInfo[] fi; fi = myType.GetFields ( BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance ); foreach (FieldInfo f in fi) { //logger.Info ( "f.GetValue( obj ) is " + f.GetValue ( item ) ); if (f.GetValue ( item ).ToString ().Equals ( strPropValue )) return (T)m_pool[typeof ( T )][i]; else continue; } //eof foreach } else continue; } //eof for j } //eof if else continue; } //eof else if m_pool.ContainsKey } return default ( T ); } //eof method // private static readonly ILog logger = //LogManager.GetLogger ( typeof ( DH.ObjectPool ) ); } //eof class pool } //eof namespace //namespace TestPool //{ // class Program // { // private static readonly ILog logger = //LogManager.GetLogger ( typeof ( Program ) ); //create the logging object // public static DH.ObjectPool pool = new DH.ObjectPool (); // static void Main ( string[] args ) // { // DOMConfigurator.Configure (); //tis configures the logger // #region CreateTheBusinessObjects // Animal dog = new Animal () { Name = "Fido", ID = 1 }; // Vegetable carrot = new Vegetable { Color = "Orange", Identifier = 2, IsTasty = true }; // Mineral carbon = new Mineral () { UniqueID = 3, IsPoisonousToAnimal = false, Name = "some" }; // HolderForStrings hfs = new HolderForStrings () { ID = 4, Value = "user_name", MetaName = "meta_nam" }; // HolderForStrings hfs1 = new HolderForStrings () { ID = 5, Value = "user_name", MetaName = "hfs1" }; // Mineral carbon1 = new Mineral () { UniqueID = 3, IsPoisonousToAnimal = false, Name = "some1" }; // #endregion CreateTheBusinessObjects // #region AddTheBOToThePool // pool.AddItem ( dog ); // pool.AddItem ( carrot ); // pool.AddItem ( hfs ); // pool.AddItem ( hfs1 ); // #endregion AddTheBOToThePool // #region UncommentForMoreTesting // //pool.AddItem<Animal>(dog.ID, dog); // //pool.AddItem<Vegetable>(carrot.Identifier, carrot); // //pool.AddItem<Mineral> ( carbon ); // //pool.AddItem<HolderForStrings> ( 1, hfs ); // //logger.Info("Dog is in the pool -- this statement is " + pool.ContainsKey<Animal>(dog.ID)); // //logger.Info("hfs is in the pool -- this statement is " + pool.ContainsKey<HolderForStrings>(hfs.ID)); // //logger.Info("The hfs value is from the poos is " + pool.GetItem<HolderForStrings>(4).Value); // //logger.Info("poo.GetItems is " + pool.GetItems<HolderForStrings>()); // #endregion UncommentForMoreTesting // #region while // //for (int i = 0; i < pool.Count -1 ; i++) // int i = 1; // do // { // try // { // logger.Info ( "counting" ); // logger.Info ( " i is " + i.ToString () ); // if (pool.ContainsKey<Animal> ( i )) // { // logger.Info ( " I see animal which is " + pool.GetItem<Animal> ( i ).Name ); // } // if (pool.ContainsKey<Vegetable> ( i )) // { // logger.Info ( " I see Vegetable which is " + pool.GetItem<Vegetable> ( i ).Color ); // } // if (pool.ContainsKey<Mineral> ( i )) // { // logger.Info ( " I see Mineral which is " + pool.GetItem<Mineral> ( i ).IsPoisonousToAnimal ); // } // if (pool.ContainsKey<HolderForStrings> ( i )) // { // logger.Info ( " I see string which is " + pool.GetItem<HolderForStrings> ( i ).Value ); // } // //logger.Info("pool.GetItem<HolderForStrings>(4).Value); is " + pool.GetItem<Object>(i).ToString()); // i = i + 1; // } // catch (KeyNotFoundException e) // { // continue; // } // } //eof for // while (i < pool.TotalCount); // #endregion while // #region AddHolders // ////this is the success identifier // //HoldInt16 holdVerifier = new HoldInt16() // //{ // // ID=0 , // // MetaName = "ret", // // Value = 0 // //}; // //pool.AddItem<HoldInt16>(holdVerifier.ID, holdVerifier); // //ListDictionary lidMetaName = pool.LidMetaName; // ////this is the message // //HoldString holdMsg = new HoldString( ref lidMetaName) // //{ // // ID=1, // // MetaName = "msg", // // Value = msg, // // Title = "title" // //}; // //pool.AddItem<HoldString>(holdMsg.ID, holdMsg); // //HoldString holdmmsg = new HoldString(ref lidMetaName) // //{ // // ID=2, // // MetaName = "mmsg", // // Value = "mmsg" , // // Title = "title" // //}; // #endregion AddHolders // //Utils.Debugger.DebugListDictionary(ref msg, "domainName", ref lidMetaName); // //get the value be metaName // logger.Info ( "I queried the pool by property with meta Value and value user_name " ); // HolderForStrings HolderForStrings = pool.GetItemByPropertyValue<HolderForStrings> ( "MetaName", "hfs1" ); // //logger.Info ( "object dump" + Utils.Log.ObjDumper.DumpObject ( HolderForStrings ) ); // logger.Info ( "I found the following value for property with the name \"Name\" " ); // logger.Info ( HolderForStrings.MetaName ); // Console.ReadLine (); // } //eof Main // } //eof class // #region ExampleBusinessObjects // public class Animal // { // public Int32 ID { get; set; } // public String Name { get; set; } // } // public class HolderForStrings // { // public Int32 ID { get; set; } // public String Value { get; set; } // public String MetaName { get; set; } // Type ObjType = typeof ( string ); // public Int32 Size { get; set; } // public bool IsOptional { get; set; } // public bool IsPrimaryKey { get; set; } // } //eof class // public class Vegetable // { // public Int32 Identifier { get; set; } // public String Color { get; set; } // public Boolean IsTasty { get; set; } // } // public class Mineral // { // public Int32 UniqueID { get; set; } // public Boolean IsPoisonousToAnimal { get; set; } // public String Name { get; set; } // } // #endregion ExampleOfBusinessObjects //} //eof class
 | RegExLib.com Regular Expression Cheat Sheet (.NET) |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||
Character Escapes http://tinyurl.com/5wm3wl | |
|---|---|
| Escaped Char | Description |
| ordinary characters | Characters other than . $ ^ { [ ( | ) ] } * + ? \ match themselves. |
| \a | Matches a bell (alarm) \u0007. |
| \b | Matches a backspace \u0008 if in a []; otherwise matches a word boundary (between \w and \W characters). |
| \t | Matches a tab \u0009. |
| \r | Matches a carriage return \u000D. |
| \v | Matches a vertical tab \u000B. |
| \f | Matches a form feed \u000C. |
| \n | Matches a new line \u000A. |
| \e | Matches an escape \u001B. |
| \040 | Matches an ASCII character as octal (up to three digits); numbers with no leading zero are backreferences if they have only one digit or if they correspond to a capturing group number. (For more information, see Backreferences.) For example, the character \040 represents a space. |
| \x20 | Matches an ASCII character using hexadecimal representation (exactly two digits). |
| \cC | Matches an ASCII control character; for example \cC is control-C. |
| \u0020 | Matches a Unicode character using a hexadecimal representation (exactly four digits). |
| \* | When followed by a character that is not recognized as an escaped character, matches that character. For example, \* is the same as \x2A. |
Character Classes http://tinyurl.com/5ck4ll | |
|---|---|
| Char Class | Description |
| . | Matches any character except \n. If modified by the Singleline option, a period character matches any character. For more information, see Regular Expression Options. |
| [aeiou] | Matches any single character included in the specified set of characters. |
| [^aeiou] | Matches any single character not in the specified set of characters. |
| [0-9a-fA-F] | Use of a hyphen (–) allows specification of contiguous character ranges. |
| \p{name} | Matches any character in the named character class specified by {name}. Supported names are Unicode groups and block ranges. For example, Ll, Nd, Z, IsGreek, IsBoxDrawing. |
| \P{name} | Matches text not included in groups and block ranges specified in {name}. |
| \w | Matches any word character. Equivalent to the Unicode character categories [\p{Ll}\p{Lu}\p{Lt}\p{Lo}\p{Nd}\p{Pc}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \w is equivalent to [a-zA-Z_0-9]. |
| \W | Matches any nonword character. Equivalent to the Unicode categories [^\p{Ll}\p{Lu}\p{Lt}\p{Lo}\p{Nd}\p{Pc}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \W is equivalent to [^a-zA-Z_0-9]. |
| \s | Matches any white-space character. Equivalent to the Unicode character categories [\f\n\r\t\v\x85\p{Z}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \s is equivalent to [ \f\n\r\t\v]. |
| \S | Matches any non-white-space character. Equivalent to the Unicode character categories [^\f\n\r\t\v\x85\p{Z}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \S is equivalent to [^ \f\n\r\t\v]. |
| \d | Matches any decimal digit. Equivalent to \p{Nd} for Unicode and [0-9] for non-Unicode, ECMAScript behavior. |
| \D | Matches any nondigit. Equivalent to \P{Nd} for Unicode and [^0-9] for non-Unicode, ECMAScript behavior. |
USE [GA_DEV] GO /****** Object: DdlTrigger [TraceDbChanges] Script Date: 05/07/2009 12:57:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create trigger [TraceDbChanges] on database for create_procedure, alter_procedure, drop_procedure, create_table, alter_table, drop_table, create_function, alter_function, drop_function , create_trigger , alter_trigger , drop_trigger as set nocount on declare @data xml set @data = EVENTDATA() declare @DbVersion varchar(20) set @DbVersion =(select ga.GetDbVersion()) declare @DbType varchar(20) set @DbType =(select ga.GetDbType()) declare @DbName varchar(256) set @DbName =@data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)') declare @EventType varchar(256) set @EventType =@data.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(50)') declare @ObjectName varchar(256) set @ObjectName = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)') declare @ObjectType varchar(25) set @ObjectType = @data.value('(/EVENT_INSTANCE/ObjectType)[1]', 'varchar(25)') declare @TSQLCommand varchar(max) set @TSQLCommand = @data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'varchar(max)') declare @opentag varchar(4) set @opentag= '<' declare @closetag varchar(4) set @closetag= '>' declare @newDataTxt varchar(max) set @newDataTxt= cast(@data as varchar(max)) set @newDataTxt = REPLACE ( REPLACE(@newDataTxt , @opentag , '<') , @closetag , '>') -- print @newDataTxt declare @newDataXml xml set @newDataXml = CONVERT ( xml , @newDataTxt) declare @Version varchar(50) set @Version = @newDataXml.value('(/EVENT_INSTANCE/TSQLCommand/CommandText/Version)[1]', 'varchar(50)') -- if we are dropping take the version from the existing object if ( SUBSTRING(@EventType , 0 , 5)) = 'DROP' set @Version =( select top 1 [Version] from ga.DbObjChangeLog where ObjectName=@ObjectName order by [LogId] desc) if ( @Version is null) set @Version = '1.0.0' declare @Description varchar(max) set @Description = @newDataXml.value('(/EVENT_INSTANCE/TSQLCommand/CommandText/Description)[1]', 'varchar(max)') declare @ChangeDescription varchar(max) set @ChangeDescription = @newDataXml.value('(/EVENT_INSTANCE/TSQLCommand/CommandText/ChangeDescription)[1]', 'varchar(max)') declare @LoginName varchar(256) set @LoginName = @data.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(256)') declare @FirstName varchar(50) set @FirstName= (select [FirstName] from [ga].[LoginsForUsers] where [LoginName] = @LoginName) declare @LastName varchar(50) set @LastName = (select [LastName] from [ga].[LoginsForUsers] where [LoginName] = @LoginName) declare @SchemaName sysname set @SchemaName = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'sysname'); --declare @Description xml --set @Description = @data.query('(/EVENT_INSTANCE/TSQLCommand/text())') --print 'VERSION IS ' + @Version --print @newDataTxt --print cast(@data as varchar(max)) -- select column_name from information_schema.columns where table_name ='DbObjChangeLog' insert into [ga].[DbObjChangeLog] ( [DatabaseName] , [SchemaName], [DbVersion] , [DbType], [EventType], [ObjectName], [ObjectType] , [Version], [Description], [ChangeDescription], [SqlCommand] , [LoginName] , [FirstName], [LastName] ) values( @DbName, @SchemaName, @DbVersion, @DbType, @EventType, @ObjectName, @ObjectType , @Version, @Description, @ChangeDescription, @newDataTxt, @LoginName , @FirstName , @LastName ) GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO DISABLE TRIGGER [TraceDbChanges] ON DATABASE GO ENABLE TRIGGER [TraceDbChanges] ON DATABASE GO
using System; using System.Collections.Generic; using System.Linq; using System.Text; using log4net; using log4net.Config; namespace UserAndAction { class Program { private static readonly ILog logger = LogManager.GetLogger ( typeof ( Program ) ); static void Main ( string[] args ) { Console.WriteLine ( " START " ); XmlConfigurator.Configure( new FileInfo ( "D:\\libs\\path\\to\\App.config")); //tis configures the loo ; //tis configures the logger logger.Debug ( "Here is a debug log." ); logger.Info ( "... and an Info log." ); logger.Warn ( "... and a warning." ); logger.Error ( "... and an error." ); logger.Fatal ( "... and a fatal error." ); Console.WriteLine ( " HIT A KEY TO EXIT " ); Console.ReadLine (); Console.WriteLine ( " END " ); } } //eof class } //eof namespace
<?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" /> </configSections> <log4net> <appender name="LogFileAppender" type="log4net.Appender.FileAppender"> <param name="File" value="LogTest2.txt" /> <param name="AppendToFile" value="true" /> <layout type="log4net.Layout.PatternLayout"> <param name="Header" value="[Header] \r\n" /> <param name="Footer" value="[Footer] \r\n" /> <param name="ConversionPattern" value="%d [%t] %-5p %c %m%n" /> </layout> </appender> <appender name="ColoredConsoleAppender" type="log4net.Appender.ColoredConsoleAppender"> <mapping> <level value="ERROR" /> <foreColor value="White" /> <backColor value="Red, HighIntensity" /> </mapping> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" /> </layout> </appender> <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.2.10.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <connectionString value="data source=nameOfTheHostAndInstance;initial catalog=DbName;integrated security=true;persist security info=True;" /> <commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message]) VALUES (@log_date, @thread, @log_level, @logger, @message)" /> <parameter> <parameterName value="@log_date" /> <dbType value="DateTime" /> <layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" /> </parameter> <parameter> <parameterName value="@thread" /> <dbType value="String" /> <size value="255" /> <layout type="log4net.Layout.PatternLayout" value="%thread" /> </parameter> <parameter> <parameterName value="@log_level" /> <dbType value="String" /> <size value="50" /> <layout type="log4net.Layout.PatternLayout" value="%level" /> </parameter> <parameter> <parameterName value="@logger" /> <dbType value="String" /> <size value="255" /> <layout type="log4net.Layout.PatternLayout" value="%logger" /> </parameter> <parameter> <parameterName value="@message" /> <dbType value="String" /> <size value="4000" /> <layout type="log4net.Layout.PatternLayout" value="%message" /> </parameter> </appender> <root> <level value="INFO" /> <appender-ref ref="LogFileAppender" /> <appender-ref ref="AdoNetAppender" /> <appender-ref ref="ColoredConsoleAppender" /> </root> </log4net> </configuration>
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Reflection; namespace MustHaveAttributes { [AttributeClass ( "Yordan Georgiev", "1.0.0" )] class Program { static int Main ( string [] args ) { bool flagFoundCustomAttrOfTypeAttributeClass = false; Console.WriteLine ( " START " ); // what is in the assembly Assembly a = Assembly.Load ( "MustHaveAttributes" ); Type[] types = a.GetTypes (); foreach (Type t in types) { object[] arrCustomAttributes = t.GetCustomAttributes ( true ); if (arrCustomAttributes == null || arrCustomAttributes.GetLength ( 0 ) == 0) { //DO NOT CHECK IN ExitProgram ( t, "Found class without CustomAttributes" ); } foreach (object objCustomAttribute in arrCustomAttributes) { Console.WriteLine ( "CustomAttribute for type is {0}", t ); if (objCustomAttribute is AttributeClass) flagFoundCustomAttrOfTypeAttributeClass = true; } if (flagFoundCustomAttrOfTypeAttributeClass == false) { //DO NOT CHECK IN ExitProgram ( t, "Did not found custom attribute of type AttributeClass" ); } Console.WriteLine ( "Type is {0}", t ); } Console.WriteLine ("{0} types found", types.Length ); //NOW REQUIREMENTS IS PASSED CHECK IN Console.WriteLine ( " HIT A KEY TO EXIT " ); Console.ReadLine (); Console.WriteLine ( " END " ); System.Environment.Exit ( 0 ); return 0; } static void ExitProgram ( Type t, string strExitMsg ) { Console.WriteLine ( strExitMsg ); Console.WriteLine ( "Type is {0}", t ); Console.WriteLine ( " HIT A KEY TO EXIT " ); Console.ReadLine (); System.Environment.Exit ( 1 ); } } //eof Program //This will fail even to compile since the constructor requires two params //[AttributeClass("OnlyAuthor")] //class ClassOne //{ //} //eof class ////this will not check in since this class does not have required custom ////attribute //class ClassWithoutAttrbute //{ } [AttributeClass("another author name " , "another version")] class ClassTwo { } //eof class [System.AttributeUsage ( System.AttributeTargets.Class | System.AttributeTargets.Struct, AllowMultiple = true )] public class AttributeClass : System.Attribute { public string MustHaveDescription { get; set; } public string MusHaveVersion { get; set; } public AttributeClass ( string mustHaveDescription, string mustHaveVersion ) { MustHaveDescription = mustHaveDescription; MusHaveVersion = mustHaveVersion; } } //eof class } //eof namespace
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Reflection; namespace WriteNameSpace { class WriteClass { static void Main ( string[] args ) { Console.WriteLine ( " START " ); Console.ReadLine (); Console.WriteLine ( " HIT A KEY TO EXIT " ); Console.WriteLine ( " END " ); } } //eof Program } //eof namespace
USE [DBGA_DEV] GO /****** Object: DdlTrigger [trigMetaDoc_TraceDbChanges] Script Date: 04/10/2009 21:31:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create trigger [trigMetaDoc_TraceDbChanges] on database for create_procedure, alter_procedure, drop_procedure, create_table, alter_table, drop_table, create_function, alter_function, drop_function , create_trigger , alter_trigger , drop_trigger as set nocount on declare @data xml set @data = EVENTDATA() declare @DbVersion varchar(20)=(select ga.GetDbVersion()) declare @DbName varchar(256)=@data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)') declare @DbType varchar(50)=(select ga.GetDbType()) declare @EventType varchar(256)=@data.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(50)') declare @ObjectName varchar(256) = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)') declare @ObjectType varchar(25) = @data.value('(/EVENT_INSTANCE/ObjectType)[1]', 'varchar(25)') declare @TSQLCommand varchar(max) = @data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'varchar(max)') declare @LoginName varchar(256) = @data.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(256)') declare @FirstName varchar(50)= (select [FirstName] from [ga].[tb_BLSec_LoginsForUsers] where [LoginName] = @LoginName) declare @LastName varchar(50) = (select [LastName] from [ga].[tb_BLSec_LoginsForUsers] where [LoginName] = @LoginName) declare @SchemaName sysname = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'sysname'); declare @Description xml = @data.query('(/EVENT_INSTANCE/TSQLCommand/text())') print cast(@data as varchar(max)) declare @Desc varchar(200) = @Description.value('(/Description)[1]' , 'varchar(200)') print @TSQLCommand print @Desc -- select column_name from information_schema.columns where table_name ='tb_DataMeta_ObjChangeLog' insert into [ga].[tb_DataMeta_ObjChangeLog] ( [DatabaseName] , [SchemaName], [DbVersion] , [DbType], [EventType], [ObjectName], [ObjectType] , [SqlCommand] , [LoginName] , [FirstName], [LastName] ) values( @DbName, @SchemaName, @DbVersion, @DbType, @EventType, @ObjectName, @ObjectType , @TSQLCommand, @LoginName , @FirstName , @LastName ) -- if eventType like create -> add ext props ; -- if eventType like alter -> update ext props ; -- if eventType like drop -> -- select name from sys.tables where name like '%ext%' GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO DISABLE TRIGGER [trigMetaDoc_TraceDbChanges] ON DATABASE GO ENABLE TRIGGER [trigMetaDoc_TraceDbChanges] ON DATABASE GO
-- get stored procedure name , it's ext prop name and value SELECT sp.name , ep.name , ep.value from sys.extended_properties as ep inner join sys.procedures as sp on ep.major_id = sp.object_id --get ext props name value for tables SELECT sp.name , ep.name , ep.value from sys.extended_properties as ep inner join sys.tables as sp on ep.major_id = sp.object_id
Posts
All Comments
