Generate database schema from the database diagram in MS Visio 2010(Visio Forward Engineer)

 

Even though Microsoft Visio 2010 shipped with reverse engineering facility its does not have the capability of forward engineering .But there is a addin in CodePlex which gives the forward engineer capability to the Visio.Somehow Microsoft decided not to include this feature in 2010 version of Visio.

download and install above addin from below link :

Forward Engineer

After install reopen the Visio.then you will be able to see new tab called Forward Engineer.

Validate Data Model :This will validate your data model and if any error found displays in the output window

Forward Engineer :If there are no errors after the validation you can generate the query for the designed schema.

The contract name 'IMetadataExchange' could not be found in the list of contracts implemented by the service PersonService. Add a ServiceMetadataBehavior to the configuration file or to the ServiceHost directly to enable support for this contract.

 

Add Service meda data information to the config file.

<behavior name="serviceBahbiour">
         <serviceMetadata  httpGetEnabled="false"/>
</behavior>

HTTP could not register URL http://+:8000/TestService/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details).

 

I have hosted wcf service in Console Application and run ,Then my app prompt below exception.

Solution for this is running the the CosoleApp/Visual Studio in Admin Mode

load test application itself does not have an app.config file?

 

I am load testing a WCF project using VS2010 load testing manager , that uses an app.config file to load configuration properties. But the problem is load test application itself does not have an app.config file. there for what I have done is add the .config file to the ny load testing project and its works charmly

Could not find a base address that matches scheme net.tcp for the endpoint with binding NetTcpBinding. Registered base address schemes are [http].

 

Recently I have create WCF service and hosted in IIS 7.5 under was.

Then I investigate the reason and found the reason.In order to over come this issue we need to have both http,net.tcp protocols in hosted web application advanced settings under Behavior section.

.

No connection could be made because the target machine actively refused it error in WAS hosted WCF service

 

Recently I have created wcf service which is on NetTCPBinding and hosted in WAS.But when I try to create proxy using WCFtestClient its always failed prompting this error.

The reason for this is the host sent a reset signal, instead of an ack when the client tried to connect. It is therefore not a problem in the code. Either there is a firewall blocking the connection or the process that is hosting the service is not listening on that port.

• There fore we need to marks service port  as allowed port in the server firewall by defining new rule.
• Need to running NetTcpPort Sharing windows service and Net.Tcp  Distner adapter windows service.

After doing above two steps its works   

Doesn’t show windows authentication in IIS 7

Recently when I try to deploy my web application to newly setup windows server, in the IIS it doesn’t listed the windows authentication option  under authentication

In order to have listed windows authentication you need to install it by going to the Server Manager and checking Windows Authentication Check box

Server Manager—>web Service--->Add Role Service

Note : - In this machine already installed the Windows authentication .other wise check box will be enabled.