Category: XPath
Building a new .NET Enterprise Application from the ground up.
Summary
From January 2006 to present working with a team of Senior Software Engineer’s architecting and implementing a new enterprise application responsible for translating Electronic Data Interchange (EDI) into a format usable by back-end business applications (SAP 2005, MAS 500, PeachTree and QuickBooks) in order to minimize or eliminate the need for manual data entry.
Responsible for designing and coding all layers of the applications architecture including User Interface (WinForms\ASP.NET WebForms), Service (ASP.NET Web Services), Business and Data Access (SQL Server 2005).
Client-Side User Interface utilized a loosely coupled Model View Presenter (MVP) design pattern in order to support multiple client platforms (Windows and Web).
The Service Layer was built for maximum scalability by adhering to a strict Service-Oriented Architecture that utilized Microsoft’s ASP.NET Web Service technologies.
The Business Layer consists of C# assembly libraries that leverage core .NET Framework 2.0\3.5 technologies.
The Data Access Layer uses Microsoft’s Enterprise Library Data Access Application Block [DAAB] to abstract and simplify back-end SQL Server 2005 data access. All SQL DML is encapsulated in Microsoft Transact (T-SQL) Stored Procedures.
Tools and Technologies Leveraged
Development environments
Visual Studio 2005\2008, SQL Server Management Studio
Technologies
Infragistics NetAdvantage 2006-2009, SQL Server Management Objects (SMO), IIS, ASP.NET Web Services, Distributed Transaction Coordinator (DTC), Web Service Enhancements (WSE 3.0), ADO.NET (connected and disconnected), SQL-CLR
Languages
C#, SQL, T-SQL, XML, XPath, XQuery
Databases
SQL Server 2005