DotNetSlackers Latest ASP.NET News in Category XSD

Simple Class Creator

The Code Project Latest Articles — Tue, 08 May 2012 00:00:00 GMT

A very simple class code generation tool. Input a simple select statement and generate code for the schema of the returned virtual table....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Parsing and interpreting Xsd using Linq

The Code Project Latest Articles — Sun, 06 May 2012 00:00:00 GMT

How to use a Linq2Xsd generated object to directly manipulate XmlSchema...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

EF5: Where are my DataAnnotations?

Julia Lerman Blog - Dont Be Iffy... — Tue, 03 Apr 2012 00:00:00 GMT

EF 4.x: EF 4.1+ has a DataAnnotations namespace for the new EF related annotations. Most of them are related to database schema. EF 5 Not even a DataAnnotations namespace in here. Thats because the annotations got incorporated into .NET 4.5. .NET 4.5 A new namespace within System.ComponentModel.DataAnnotations: Schema All of the EF schema annotations are in here now. MaxLength and MinLength are in the DataAnnotations namespace. Added the following thanks to a suggestion from...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Adding a New Field to the Movie Model and Table

ASP.NET Daily Articles — Fri, 09 Mar 2012 00:00:00 GMT

In this section you'll make some changes to the model classes and learn how you can update the database schema to match the model changes. Adding a Rating Property to the Movie Model Start by addin...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

New EF Code First Migrations Video on Pluralsight

Julia Lerman Blog - Dont Be Iffy... — Wed, 07 Mar 2012 00:00:00 GMT

My newest course is live on Pluralsight.com. This one is about using the new data migrations feature of Entity Framework Code First. These were first introduced with EF 4.3. Migrations lets you update your database schema when your model changes rather than having code first completely drop and recreate the database. This lets you retain data and any other existing database objects that arent described in the model (e.g., triggers, functions, etc.) Entity Framework Code First Migrations (total...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Telerik OpenAccess ORM Q1 2012 - Batch Operations

the telerik blogs — Fri, 17 Feb 2012 00:00:00 GMT

In previous versions of OpenAccess ORM, configuring large data models could be a bit cumbersome. However, I am happy to say that in Q1 2012 we are adding a new batch operation dialog, which makes configuring data models easier than ever! Using the Batch Operation Wizard, developers can efficiently make updates to several entities, or members, in a single operation!

To launch the batch operation dialog, right click on the visual design surface, and select Batch Operations.

This menu item launches the new wizard:

On the left side of the wizard is a search area. This allows developers to search for entities, or members, by different criteria. The search results are displayed in the grid in the center of the dialog; by default all items are displayed. Once you select a few items from the center grid, a batch operation can be applied using the panel on the right.

In this example, I filtered the entities down using the underlying table’s schema. I then moved all of the entities into the namespace Production, and clicked the execute button to make the change. As you can see this affected 25 entities in the domain model.

As I mentioned, this dialog can also do batch operation on members. In the search pane on the left, select the Members radio button. At this point the grid will switch to show all members in the domain model. Once again you can filter them down using various criteria. After you find the members that need modification, select them, and using the right panel apply a batch operation.

In this example, I searched for all string properties in the ProductReview class, and updated the length property.

When you open the wizard, you may notice that the length column is not visible in the grid. No worries! The grid can be customized to show many different properties. To add/or remove columns to the center grid, simply right click on the header section, and you will be greeted by a handy column picker!

The new batch operation dialog significantly increases developer productivity by allowing domain model changes to be made in bulk. Gone are the days of making changes entity by entity, or member by member!

We hope you enjoy this new feature, and as always we look forward to any feedback you may have!

The latest Telerik release is just around the corner and we have tons of new stuff to show off. If you are eager to see the new bits and sharpen your .NET skills, be sure to sign up for Release Webinar Week. This 3-day event is packed with hour-long webinar sessions on the coolest new features shipping with the Q1 2012 release. Release Webinar Week will be held on February 20 – 22, so mark your calendars.

One lucky winner from each webinar will leave with a Telerik Ultimate Collection license worth $1999. To enter the drawing and participate in the Q&A session, you must attend the live webinar.

Happy Coding!

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Building your own Racing Simulator Dashboard with some Arduino and VB.Net

MSDN: Coding4Fun — Fri, 10 Feb 2012 00:00:00 GMT

Today's Hardware Friday post is kind of thing that many gamers lust for, a hardware extension for their simulator of choice, be it as complicated as a airplane cockpit in their garage or something a little more approachable like a DIY hardware dashboard for your racing simulator.DIY DashboardThe dashboard Im posting here have the following features:RPM lights Gear indicator Pit limiter, rev limiter and low fuel indicators 5 general purpose switches and buttons 1 rotary encoder for dialing I bought...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

DB2 SET CURRENT SCHEMA

DBA DB2 — Fri, 13 Jan 2012 00:00:00 GMT

Within a database multiple SCHEMAS can exist. If a table or view exists in a schema different from the default SCHEMA of the logon and the reference to the object does not include a qualified name , then the object cant be found. For example , you may want to do a db2 list tables and view the list pf tables from another schema. Use the SET CURRENT SCHEMA method. For example , If the default SCHEMA is DB2TEST , and you want to view the tables of the schema DB2OTHER do: See Also ADMIN_DROP_SCHEMA...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

ALTER SCHEMA

SQL Server DBA — Mon, 24 Oct 2011 00:00:00 GMT

Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server 2005 database. dbo can be changed to whatever schema name required USE myDb GO SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name FROM sys.Procedures p INNER JOIN sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = 'mySchema' order by p.Name Use this select statement to create a list of ALTER SCHEMA statements for all tables and views in a SQL Server 2005...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

On your mark, get set... Grand Prix/Pinewood Derby Track Timer, via Netduino

MSDN: Coding4Fun — Fri, 21 Oct 2011 00:00:00 GMT

Today's Hardware Friday Coding4Fun project is one that brings back a number of memories. From being a kid and building and racing in the Pinewood Derby, to those as a parent of a racer, to the "discussions" of which car won. In short, I wish I had this then...Project Grand Prix (Pinewood Derby) TimerSo let me set the stage for you (in case you didnt do Awana Grand Prix or Boy Scouts Pinewood Derby as a kid). You are 9 years old you and your Dad (or Mom) have just spend 2 weekends building a pine...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

ADMIN_DROP_SCHEMA to drop a schema

DBA DB2 — Tue, 02 Aug 2011 00:00:00 GMT

I use ADMIN_DROP_SCHEMA to drop a schema and its objects. The main advantage of using the procedure , instead of writing a customised script is there could be routines such as stored procedures or UDFs with cross dependencies and require to be dropped in a certain order. An example is CALL SYSPROC. ADMIN_DROP_SCHEMA ( schema_name, NULL, 'error_table_schema','error_table_name') ---Use this sql to view the errors: SELECT * FROM error_table_schema.error_table_name Certain objects...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Indexes in DB2

DBA DB2 — Wed, 13 Jul 2011 00:00:00 GMT

How to create a recordset of indexes in DB2 for a table? ---To list all indexes for a schema and table db2 "Select indschema,indname,uniquerule,colnames from syscat.indexes where tabschema = '<MY_SCHEMA>' and tabname='<MY_TABLE>' order by indname" Author: Jack Vamvas(http://www.dba-db2.com) ...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

DB2 list schemas of a database

DBA DB2 — Mon, 11 Jul 2011 00:00:00 GMT

How to do a DB2 list schemas ? Step 1 Connect to the database db2 connect to my_database Step 2 Execute this query select schemaname from syscat.schemata The recordset is something like : Author: Jack Vamvas(http://www.dba-db2.com) ...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Wait, isn`t that MP3, THAT MP3? Fingerprinting your music/audio...

MSDN: Coding4Fun — Wed, 15 Jun 2011 00:00:00 GMT

We've recently been hearing a good bit about music fingerprinting. Where some service or other looks at the fingerprints of your music and then does something with that data. If you're like me, you've wondered just how that fingerprinting is done and how I could do something like that too. Yet I'd not seen any technical explanations or code examples. That is until...Duplicate songs detector via audio fingerprintingAs a software engineer, I was always interested in how a computer can be taught to...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Tron Disc with .NET Microframework

MSDN: Coding4Fun — Mon, 13 Dec 2010 00:00:00 GMT

Harford Hackerspace David Powell Jeremy Ashinghurst Paul King Jason McMahon Source Code: Download Difficulty: Advanced Time Required: 10+ hours Software Needed: MicrosoftVisualC# Express 2010, Microsoft .netMicroFrameworkSDKv4.1, NetduinoSDKv4.1.0 Hardware: List below Introduction We wanted to make our own Tron Identity Disc using the Netduino, allowing...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Tailspin Spyworks Ecommerce Application and Tutorial Updated on CodePlex !

MS-Joe — Mon, 15 Nov 2010 00:00:00 GMT

Just a note to let folks know that Ive updated both the code and the tutorial for the tailspin Spyworks sample app at http://tailspinspyworks.codeplex.com/. It includes bug fixes, additional step details in the tutorial as well as complete database schema information. Enjoy and feel free to send comments and suggestions. ...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Service Testing in SO-Aware

Pablo M. Cibraro (aka Cibrax) — Tue, 03 Aug 2010 00:00:00 GMT

Service testing is another interesting feature that you will find in SO-Aware. Having a tool for testing a service in the repository is very important for the following reasons, You can make sure the service up and running (The service deployment and configuration was done correctly). The service is responding to the different requests generated by the tests. You can have a better idea of the service availability over the time As SO-Aware is mostly oriented to WCF services, and also...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Oracle and 3rd Party Tools

Simple Talk — Thu, 08 Jul 2010 00:00:00 GMT

We knew before we started to create Schema Compare for Oracle that wed need to work hard. It is a different technology and a different market. Also, there is less interest amongst Oracle users for third-party tools. Why? Nobody we asked could explain, so we tried to find out....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Book Review: The Art of XSD - SQL Server XML schemas

Simple Talk — Thu, 10 Jun 2010 00:00:00 GMT

The 14 chapters of "The Art of XSD, written by MVP Jacob Sebastian, will take the reader step-bystep all the way from the basics of XML Schema design all the way to advanced topics on SQL Server XML Schema Collections. Reviewer Hima Bindu Vejella gives it an 8/10 rating, and gives us an excellent distilled description of what the book has to offer....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Mapping Help in the EDM Designer

Julia Lerman Blog - Dont Be Iffy... — Wed, 26 May 2010 00:00:00 GMT

The mapping details window that displays the mappings between an entity and database table(s) is pretty straightforward. When you join two related tables in a Table Per Hierarchy inheritance things can get a little confusing when it comes to the mappings for inherited properties. But did you know that the Mapping Details window uses the Properties window to help? Here are two entities in a TPH hierarchy. Customer inherits Contact. Customer maps to a Customers table which uses ContactID as...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.