Posts

Difference between PCL and ClassLibrary

PCL Portable class libraries are platform independent They do not use conditional compilation and unmanaged code, they have no UI inside (UI is platform dependent) This is because PCL should work on all specified platforms which was chosen as a target. Also, availability of features depends on selected targets. PCL can be referenced by any project which target is specified in the PCL settings. Class Library Class Libraries are not platform independent. No conditional compilation, they too have no UI inside. Class Libraries of other types can be referenced only by projects which have the same target or by upper subsets of .Net

Difference between PCL and Shared Project in Xamarin

PCLs Portable Class Libraries allow you to write code and produce libraries that can be shared across mulitple platforms including Xamarin.iOS, Xamarin.Android and Windows Phone. Portable Class Libraries (PCLs) can be created in both Xamarin Studio and Visual Studio, and then referenced in each platform-specific project to allow code to be easily shared. Shared Project Shared Projects (also sometimes called Shared Asset Projects ) let you write code that is shared between multiple target projects including Xamarin applications. They support compiler directives so that you can conditionally include platform-specific code to be compiled into a subset of the projects that are referencing the Shared Project. There is also IDE support to help manage the compiler directives and visualize how the code will look in each application. If you have used file-linking in the past to share code between projects, Shared Projects works in a similar way but with much improved IDE support. ...

ADO.Net Interview Questions

Q.  What is DataTable in ADO.NET? DataTable represents a single table in a database. In this show row and column. DataSet is a collection of data tables. In this store data record. DataTable representation in c# code, protected   void  BinddataTable()   {       SqlConnection con =  new  SqlConnection( "your database connection string" );       con.Open();       SqlCommand cmd =  new  SqlCommand( "Write your query or procedure" , con);       SqlDataAdapter da =  new  SqlDataAdapter(cmd);       DataTable dt =  new  DataTable();       da.Fill(dt);       grid.DataSource = dt;     ...

Difference between SOAP and REST

SOAP ( Simple Object Access Protocol ) SOAP can run on TCP/UDP/SMTP/HTTP. SOAP read and write request response messages in XML format. SOAP is more secure as it has its own security and well defined standards. SOAP uses SOAP-UI as client tools for testing. REST ( Representational State Transfer ) REST uses underlying HTTP protocols. REST can read and write request response messages in JSON/XML/Plain HTML. REST is stateless. REST services are cache able.  REST has light weight client tools or plugins that can easily be integrated inside browser.

Top Sql Server Interview questions for Experienced

1. What are the two authentication modes in SQL Server? There are two authentication modes – Windows Mode Mixed Mode Modes can be changed by selecting the tools menu of SQL Server configuration properties and choose security page. 2.  What Is SQL Profiler? SQL Profiler is a tool which allows system administrator to monitor events in the SQL server.  This is mainly used to capture and save data about each event of a file or a table for analysis. 3. What is recursive stored procedure? SQL Server supports recursive stored procedure which calls by itself. Recursive stored procedure can be defined as a method of problem solving wherein the solution is arrived repetitively. It can nest up to 32 levels. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 CREATE PROCEDURE [ dbo ] . [ Fact ] ( @ Number Integer , @ RetVal Integer OUTPUT ) AS DECLARE @ In Integer DECLARE @ Out Integer IF @ Number !=...