WCF Discovery with UDP
Inorder to call the WindowsCommunicationFoundation service, a port or pipe which assigned to the service must be available and the client must know the address endpoints before calling the services.
If the service could use any available address then client can discover that address at runtime. There is a industry standard-based solution which helps in discovering the service addresses.
Address Discovery
Discovery relies on the User Datagram Protocol(UDP). Client uses UDP to broadcast discovery requests for any end-point which supports the contract type. These requests are received by dedicated end-points. The end-points responds back to the client with service-address that support specified contract.
WCF offers a standard discovery endpoint with the type UdpDiscoveryEndpoint
Related Posts:
No commentsRemote Desktop Sessions from Commandline
You will commonly see the following error message when you try to connect windows 2003 server using RemoteDesktopConnection.
“The terminal server has exceeded the maximum of allowed connections ”
You can disconnect the other remotely logged in users if you are a domain Admin user. Most of the users some time not even be using the sessions.
To see the list of remote sessions in the command window, type the following command.
qwinsta /server:<ServerIP>
Example:
qwinsta /server: 192.168.219.2
Related Posts:
No commentsWCF Service using ASP.NET AJAX Library
More often, the data to shown in an AJAX page is retrieved from the Web server using a Web service, a Windows Communication Foundation (WCF) service. The services that can also return JavaScriptObjectNotation(JSON) are potential candidates for AJAX pages.
This post explains about calling a WCF service using ASP.NET AJAX Library Data View control. The following are the steps to create and call the service using ASP.NET AJAX Library.
1. Creating a AJAX enabled WCF service
2. Loading the required scripts
3. Calling a service using ASP.NET AJAX Data View Control
Related Posts:
1 commentMaster-Detail Views using ASP.NET AJAX
Master-Detail Views are very common in data-driven Web pages. These views are used for rendering one-to-many relationships. ASP.NET Web forms provided the strong server controls like grids,lists and drop-down lists which supports the multiple levels of data.
In Master-Detail View we normally navigate among master records and drill down into the details of the records that are of interest. In classic Web forms we need trigger many post-backs which most of the users are not happy these days.
This post explains about building a Master-Detail View using ASP.NER AJAX Library.
The DataView Client control is the fundamental tool for building master-derail views in ASP.NET AJAX and it can be used to generate both Master and Detail views.
Basic steps to build the Master-Detail application using ASP.NET AJAX
1. Create markup for the master and detail views.
2. Attach the DataView control to each view.
3. Use data-binding expressions to populate the data to the controls.
Related Posts:
No commentsASP.NET AJAX Library Beta in Visual Studio
Overview
The ASP.NET AJAX Library is a JavaScript library which enables the developer to build highly interactive Ajax applications. Using ASP.NET Ajax client controls we can take the advantage of building database-driven web applications. This post explains how to add these controls to Visual Studio toolbox and explore the beta features.
The ASP.NET AJAX Library is compatible with Visual Studio 2008 and Visual Studio 2010 beta when targeting ASP.NET 3.5.
Using the ASP.NET AJAX Library Beta Scripts
There are two ways that we can use AJAX Library scripts in a web applications.
- Adding controls from AJAX library to Visual Studio Toolbox.
- We can instantiate ASP.NET AJAX Controls in JavaScript Code.
Related Posts:
2 commentsRuntime Settings with SSIS Package
Introduction
Clients may require to integrate the SSIS packages in their environment(Production). SSIS package settings needs to be changed at run time and all settings needs to be pulled from the database using set of stored procedures.
1. Create a SSIS package and drag the Execute SQL task to control flow in the package as follows
Related Posts:
1 commentDomain Model Using UML
Introduction
Unified Modeling Language is a graphical language used to describe objects in a system. This post describes the UML class diagrams and relationships among business entities in the system.
Domain Model represents the relation ship between logical entities in the system. It also illustrates how different entities in application domain would interact with each other.
Class
Relationships
Related Posts:
No commentsASP.NET Application Architecture Steps
Introduction
If you have good logical skills and aptitude then it can be easier for learning programming languages. Unlike programming Software Architecture requires years of experience to master. Software Architecture is a guide to shape your project and Architecture of a system is nowhere related to the code that you write for this system. This post explains the architectural steps involved in application development.
Software Architecture is simply blueprint of your application. Software Architecture is closely related to the business needs of the project and it is not concerned about technology on which the project built upon.
Software Design deals with the implementation of the architecture which includes what design patterns to use to make the application scalable, what development methodology that we use in development phase. Basics about software architecture can be found here.
Business Requirements
Assume the following are the high-level specifications of the requirements
· System should be accessible from any location.
· System should be able to process multiple tasks.
· System should be able to process information from different databases.
· System should interact with other software packages.
Software Architecture Specification
Architecture specification for the above requirement
- The system should be web based
- The system should have built-in multithreading capabilities.
- The system should be database-independent.
- The system should expose APIs to import and export data from other sources.
Software Design Specification
Choosing a design pattern- Design patterns are proven solutions to the business problems. It tells us how we can achieve a solution in-terms of implementation.
We will need to customize the design-patterns to meet your unique needs.
Use Case Design: Creating use-case document which explains the interaction between the application and the end user. It lists the interaction steps sequentially. Each use-case should capture a specific scenario from end-to-end.
Prototyping
For Web projects, designing a working prototype in HTML before starting to work on developing is really helpful. Properly-Linked HTML pages with some dummy data shows the important business process flows and answers the business-related questions. It is highly recommended to develop a prototype before the actual coding for a project.
Class Model
The Architect and Technical lead will create an object model of the system which specifies important entities in the system and how they will interact.
Database Model
A database model would be created based on the class model described above. The use-cases, class model and database model will help the development team with clear instructions. Based on this project manager will highlight the milestones of the development phase.
Development-Phase
Identify and Separate the different components in the application. This separation can be at two levels
- Physical Separation: We separate code physically into different assemblies. Each assembly or component can be deployed to servers across the geographical locations. We also call this as n-tier architecture.
- Logical Separation: Separating the code logically into different layers, but the entire application will be part of a single assembly and can be deployed to single server. Unlike physical or tier architecture it is not possible to deploy parts of the application in a distributed manner.
Programming the layers
- Web forms as the presentation layer
-Usually contains the graphical display components like ASPX pages,
Master pages and style sheets.
- C# or VB code for handling the business logic as the Business Logic Layer (BLL).
-Usually contains business rules and presents the data to presentation layer. This layer may also include code for error handling and logging.
- Data Access code as the Data Access Layer (DAL).
- This layer is a set of classes used to encapsulate data access methods. DAL’s primary job is to communicate with the database and pass it to the business logic layer.
Conclusion
This post examined the difference between tiers and layers and the different ways we can structure our project using tiers and/or layers in ASP.NET application.
Related Posts:
No commentsETL Process using SQL server SSIS
This post explains about creating a SSIS package for demonstrating the small ETL process using transforms and connections in SQL server 2005.
1. Create a new SSIS package and drag a DataFlow task onto the control flow. Double click the task to go to the Data Flow tab.
2. In the Data Flow tab, drag an OLEDB Source onto the design pane. Select the data connection to Adventure Works Database.
3. Make sure that the Data Access Mode option is set to “Table or View”. Select the [Production].[TransactionHistoryArchive] table from Table drop-down box.
4. Select the ProductID,Quantity and ActualCost columns and say OK to exit the editor.
5. Drag a Derived Column transform to dataflow and connect the dataflow task to this task.
6. Double-click on the Derived Column transform to open the editor and type the new column with name TotalCost and configure the column as follows and click ok to exit the editor.
7. Drag an Aggregate transform onto the data flow and connect the arrow from Derived Column transform onto this transform. Double click the editor to configure the properties.
8. Drag a Sort transform onto data flow pane, connect Aggregate transform to this transform by the green arrow. Double-click on transform to configure the properties. Click OK to exit the editor.
9. Now we export this data to a flat file so that interested parties can read the file. Drag a Flat File dataflow to pane and connect the Sort transform by using the green arrow.
10. Double click on Flat File transform to get the following editor.
11. Now execute the package and you should be see the rows flow through the package as shown below
Conclusion
In this post, we have seen how transformations in SSIS allows us to change the data from a source and pass the results as output to a destination or another transform.
Related Posts:
1 commentUsing File System Task and FTP Task in SQL server SSIS
Tasks are fundamental units in SSIS control flow. Every task in SSIS needs to be configure with required fields. This post going to explain how to use FTP and File System task. You can use the File System to automate data load process.
Consider a scenario where you receive a file from source system via FTP and your package needs to be react by moving it to another working directory.
1. Create a new SSIS package using BIDS and drag the FTP task to the design pane.
2. Double click the task to set the properties
Type a name for the task and set the FTPConnection properties as shown above.
Go to File Transfer page and select the value for remoteVariable. Click Ok to exit the editor. After file being downloaded then you can copy to the local folder for achieving. To copy the file into an archive directory, we will use the File System task. Drag the task to designer and configure the properties.
In the control tab, connect the FTP file task to the File System task with a precedence constraint. The file will be FTPed first and then copied to the archived folder.
![Recommend [kalyanms1]](http://s3.amazonaws.com/arkayne-media/img/badge/02me.png){kind=icon}
