Posts

Showing posts from January, 2013

manage SQL express 2008 via SQL developer (oracle) tool

Hi,

I downloaded SQL Server 2008 Express Edition from Microsoft Web Site.After installed SQL express, i figured out that i did not install tools such as Microsoft SQL Server Management Studio.I decided to connect via SQL Developer which comes from Oracle 11G client package instead MSSQL Management Studio. It is very easy.The first thing we have to be sure that Microsoft SQL Server JDBC Driver 3.0. exists in our system. (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en)

search text in Stored Procedures

Do you want to find any text in Stored Procedures in SQL Server Database ?

"select * from INFORMATION_SCHEMA.ROUTINES" returns Procedure,Function exist in specific database. You will see objects and details in columns.

create connections between two entities with Late Binding in Microsoft CRM 2011

Hi,

I would like to share benefits of connections in Microsoft CRM 2011 and how to build connection in 2 Entities by LateBinding.
Connected entities may be both Custom or System.


here is how the SDK describes the benefits of Connections Connections provide the following capabilities: An easy and flexible way to make a connection between two records of most Microsoft Dynamics CRM entity types. All customizable business and custom entities can be enabled for connections.An option to add useful information, such as description of the connection and the duration.An ability to create connection roles that describe the relationship between the two records, such as a relationship between a doctor and a patient, or a manager and an employee.A quick way to create multiple connections and roles for a particular record. For example, a contact may have many relationships with other contacts, accounts or contracts. In each relationship a contact may play a different role.Information for building que…

make relationship in Microsoft CRM SDK

If you want to make 1 to N relation between two entities in CRM.
You have couple ways.I would like to share two of them.

First of all;
You can make relation after creating new record .

                        CustomEntityInCRM1 referrerEntity = ...//retrieve data;
                        CustomEntityInCRM2 referencedEntity = ...//retrieve data;


                        Relationship rs = new Relationship("");
                        EntityCollection relatedEntities = new EntityCollection
                        {
                            EntityName = referencedEntity.LogicalName,
                            Entities = {
                                referencedEntity
                            }
                        };

                        referrerEntity.RelatedEntities.Add(rs, referencedEntity);
                        _serviceProxy.Update(referrerEntity);


or
you can retrieve two of them and make connection (prevent 'The collection is read-only error')


    …

Everything about Log4Net

log4net is a library to help the programmer output log statements to a variety of output targets by Apache Software Foundation (official page = http://logging.apache.org/log4net/).You can also download either source code or compiled library.
It is compatible for .net project(s) and need to know couple basic things to use in your project easily.
First of all, There is a configuration you have to set before adding into your project.
Here is a sample about inserting log into a given file.
app.config file;    <!--Start Code-->
      <?xml version="1.0" encoding="utf-8" ?>
         <configuration>
            <configSections>
                  <section name="log4net"
                  type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>   
            </configSections>
         <startup>
            <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />