SQL Server > Linked Server
A linked server allows the SQL Server Database Engine to execute commands against OLE DB data sources.
Linked servers are configured to enable the Database Engine to execute a Transact-SQL statement to another instance of SQL Server or another database such as Oracle.
OLE DB data sources can be configured as linked servers like Microsoft Access and Excel.
Advantages:
- access data from outside of SQL Server.
- execute distributed commands( queries updates, transaction) to heterogeneous data sources
Examples:
Add Microsoft Access as linked server
Microsoft SQL Server is a relational database management system developed by Microsoft.
SQL Server supports ANSI SQL, the standard SQL language like all major RBDMS.
SQL Server contains own SQL implementation named T-SQL.
SQL Server Management Studio (SSMS) is SQL Server interface tool.
SQL Server >
sys.objects >
Last modified stored procedures
Example
declare @nmb_days int = 10
SELECT * FROM sys.objects
WHERE TYPE = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < @nmb_days
Telerik >
RadGridView
RadGridView Telerik for Windows forms is a complex control that allows to display and edit tabular data from different data sources.
Telerik >
RadControls for WinForms
Telerik RadControls for WinForms includes more than 60 controls that you can use to easily build visually appealing, high performance Line of Business and Metro applications.
http://www.telerik.com/products/winforms.aspx
Telerik is a software company making of ASP.NET AJAX, ASP.NET MVC, Silverlight, WinForms and WPF controls and components, as well as .NET Reporting, .NET ORM , .NET CMS, Code Analysis, Mocking, Automated Testing, Team Productivity and Run-time Analytics Tools.
Reporting
Windows Forms
ASP.NET
C# > Interview Questions
Question:
It is possible to inherit in C# a base class written in VB.net?
Answer:
Yes, both are CLS-Compilant
