Manage database of ASP.NET 2.0 Membership & Role services in non-ASP.NET context

This article explains how to manage database of ASP.NET 2.0 Membership & Role services in non-ASP.NET context.

Technorati tags: database, dotnet, asp.net

Report Sharp-Shooter Express – Free version of Perpetuum’s .NET reporting product.

Report Sharp-Shooter Express is a free version of the well-known report generator, which provides developers with the base functionality of the product. The available features enable you to create professional reports for Windows Forms applications.Report Sharp-Shooter Express provides developers with wide capabilities for creating professional reports, however it is not possible for end users to change and modify final documents.

Report Sharp-Shooter Express supports the product functionality described on the Product page and Product Features page.

Get your free license for Report Sharp-Shooter

[Via Larkware News]

MySQL GUI- SQLyog

SQLyog MySQL GUI is the most powerful MySQL Manager and MySQL Admin Tool, combining the features of MySQL Query Browser, phpMyAdmin and various other MySQL Front Ends and MySQL Clients in a single intuitive interface.

Screenshots

Connection Manager

Connection Manager

Multiple Connections + HTTP Tunnel Settings

conn_multi_http

SSH Connection Settings with "Test Connection"

conn_ssh_test

 

The following list shows the features included in Community edition( open source and free)

  • Favorites Manager
  • HTML Schema Documentation
  • Shortcuts to generate SQL DML statements from schema definition
  • Creating/Dropping/Altering tables
  • Multi-tab Query Editor and Result-set Editor
  • Multiple Query Execution
  • Multi-threaded Query execution – Ability to stop long running queries
  • SQL Templates
  • Excel-style grid interface to view/update resultsets
  • Multi-format Blob editor
  • View data in Grid/Text Mode
  • ResultSet/Data Export to CSV/XML/HTML
  • Full Support from 3.23.38 to the latest 5.x
  • Support for all MySQL table handlers
  • Excel friendly resultsets/table-data export to clipboard/file
  • Dialog-less table and resultset editor
  • DBA Productivity
  • Restoring / Importing large SQL dumps
  • MySQL 5.x objects support
  • User Management
  • Managing hosted MySQL
  • Connection Manager
  • Index Management
  • Relationship/Foreign Key Manager
  • Reorder Columns
  • Copy objects to another Host with single click
  • Table diagnostics
  • Flush Tools
  • Object Browser
  • Creating/dropping database
  • Optimized for managing Hosted MySQL
  • Multiple database connections
  • Technology
  • Turbo Speed MySQL Management. Uses native MySQL C API – the fastest way to communicate with MySQL server
  • 100% keyboard friendly
  • Small compact binary
  • Minimal use of Registry – easy migration of User Preferences by dragging and dropping config files.
  • Non-cluttered look and feel, ability to show/hide panes

Download SQLyog

[Via help.net]

How to document DataSets

Most online resources talks about how to document class methods and properties .In this post I’m going to show how to comment your datasets to create professional and more convenient documentation .

Take a look at picture below.

DataSetDocument

To achieve such results, organize your XML tags in this way 

<summary>
[Method Sumamry]
</summary>
<value>
The dataset contains the following tables 
<remarks>
<list type="table">
 <listheader>
 <term>Table</term>
</listheader> 
 <item>
  <term>[Table Name]</term>
  </item>
</list>
</remarks>
Table [Table Name] contains the following fields: 
<remarks>
<list type="table">
 <listheader>
 <term>Field</term>
 <description>Description</description>
</listheader> 
 <item>
  <term>[Column Name]</term>
  <description>[Column Description]</description>
  </item>
</list>
</remarks>  
</value> 

The Comment snippet below, along with NDoc produced the MSDN-style formatted document.

/// <summary>
/// Gets the history entries.
/// </summary>
/// <value>
/// The dataset contains the following tables 
/// <remarks>
/// <list type="table">
///  <listheader>
///  <term>Table</term>
/// </listheader> 
///  <item>
///   <term>History</term>
///     </item>
/// </list>
/// </remarks>
/// 
/// 
/// Table History contains the following fields: 
/// <remarks>
/// <list type="table">
///  <listheader>
///  <term>Field</term>
///  <description>Description</description>
/// </listheader> 
///  <item>
///   <term>Method (<see cref="System.String"/>)</term>
///   <description>Method name</description>
///     </item>
///  <item>
///   <term>ExecutedTime (<see cref="System.DateTime"/>)</term>
///   <description>When the specific method was executed</description>
///     </item>
///  <item>
///   <term>Result (<see cref="System.float"/>)</term>
///   <description>Method result</description>
///     </item>
///  </list>
/// </remarks>  
/// </value> 

Technorati Tags:  Programming Net DataSet System.Data Document CHM