LINQ Insight Express

Introduction
  LINQ Insight Express is a Visual Studio add-in that offers useful tools for LINQ and ORM development.
       It provides tools for design-time LINQ query execution and preview of generated SQL and for profiling data access events from such ORMs as
Entity Framework, NHibernate, LinqConnect, and LINQ to SQL.

Supporting Version : VS 2010,2012,2013

I) Design-time LINQ Execution
II) LINQ Profiler

Design-time LINQ Execution
Benefits
Visual Studio Integration
Convenient Query Analysis
Design-time Operation
Support for Different Kinds of Queries
How to Use
     To view SQL for a LINQ query, perform the following steps:
     Right-click the query and select Run LINQ Query from the shortcut menu or place cursor over the query and press  CTRL+SHIFT+R.
     If your query depends on some variables, specify their values in the opened dialog box.

LINQ Profiler
Benefits
Advanced Profiler for Data Access Operations
Queries View with Summarized Information
Powerful Filtering
No Need to Modify the Project
How to Use
To start profiling a project, perform the following steps:
Open the LINQ Profiler window (select Other Windows - > LINQ Profiler from the View menu).
Click the Start profiler session button on the LINQ Profiler window toolbar.
Run the project to profile.

Download from Tool

Fluent Ribbon Control Suite

Introduction:
         Fluent Ribbon Control Suite is a library that implements an Office-like (Microsoft® Office Fluent™ user interface) for the

Windows Presentation Foundation (WPF). 
       It provides well-customized controls such as Rubbon, Gallery, QuickAccessToolbar, ScreenTip, StatusBar and so on

Supporting Version: Visual Studio 2008/2010

LinqConnect Express

Introduction:

•   LinqConnect Express is a free fast and easy to use ORM solution, developed closely to the Microsoft    LINQ to SQL technology, and supporting SQL Server, Oracle, MySQL, PostgreSQL, and SQLite.
•       It provides a powerful model designer tool with complete integration to Visual Studio - Entity Developer.

Note that this free package does not allow customization of code templates and is limited to 10 entities in the project

Supports: Visual Studio 2010/2012/2013.

Key Features

1. Wide database support 
2. Compatibility 
3. Fluent mapping support
4. Professional development team 
5. Complete toolkit provided
6. Visual model designer
7. Performance

Download from Tool

DotConnect for SQLite, Standard Edition

Introduction
 DotConnect for SQLite Standard Edition is a free of charge database connectivity solution built over ADO.NET architecture. It offers basic
functionality for developing database-related applications, web sites.

Supporting Version: Visual Studio 2008/2010/2012/2013.

Product Description:
        It is a free of charge data provider built over ADO.NET architecture and a development framework with number of innovative technologies.
       It offers basic functionality for developing database-related applications and web sites.
       It introduces new approaches for designing applications and boosts productivity of database application development.

Key Features

1. Direct access to SQLite database
2. 100% managed code
3. High performance
4. Easy to deploy
5. Supports the latest versions of SQLite database
6. All SQLite data types support
7. Operates in both connected and disconnected models
8. Extra data binding capabilities
9. Cross-form components cooperation
10. Free of charge

    DotConnect Express for SQLite supports SQLite engine version 3 and higher.
    The provider works with .NET Framework 2.0, 3.0, 3.5, and 4.0.

Download from Tool

StringCollection Class

Represents a collection of strings.
StringCollection accepts Nothing as a valid value and allows duplicate elements.
String comparisons are case-sensitive.
Elements in this collection can be accessed using an integer index. Indexes in this collection are zero-based.

Syntax:

  Dim sColl As New StringCollection()
  Dim colArr() As String = {"RED", "GREEN", "YELLOW", "BLUE"}
      sColl.AddRange(colArr)

ListDictionary Class

Implements IDictionary using a singly linked list.
Recommended for collections that typically contain 10 items or less.
It is smaller and faster than a Hashtable
This should not be used if performance is important for large numbers of elements.

Members, such as Item, Add, Remove, and Contains are O(n) operations, where n is Count.

Syntax:

For Each direntry As DictionaryEntry In myListDictionary
  ...
Next direntry

PowerModes in Microsoft.Win32

• Resume The operating system is about to resume from a suspended state.
• StatusChange A power mode status notification event has been raised by the operating system. This might indicate a weak or charging battery, a transition between AC power and battery, or another change in the status of the system power supply.
• Suspend The operating system is about to be suspended.

Microsoft.Win32 Namespace

The Microsoft. Win32 namespace provides two types of classes: those that handle events raised by the operating system and those that manipulate the system registry.

SystemEvent Class

Provides access to system event notifications. This class cannot be inherited.

• DisplaySettingsChanged Event
• DisplaySettingsChanging Event
• EventsThreadShutdown Event
• InstalledFontsChanged Event
• LowMemory Event
• PaletteChanged Event
• PowerModeChanged Event
• SessionEnded Event
• SessionEnding Event
• SessionSwitch Event
• TimeChanged Event
• TimerElapsed Event
• UserPreferenceChanged Event
• UserPreferenceChanging Event

Expose Keys in Registry

CurrentUser
Stores information about user preferences.
LocalMachine
Stores configuration information for the local machine.
ClassesRoot
Stores information about types (and classes) and their properties.
Users
Stores information about the default user configuration.
PerformanceData
Stores performance information for software components.
CurrentConfig
Stores non-user-specific hardware information.
DynData
Stores dynamic data.