Get started for free
Announcement: 6

Innovate on Office announcements

  • Link
    Annoucement of the Innovate on Office forum archivement
    Ji.Zhou

    Hello forum users,

     

    This forum was created for the Innovate on Office 2007 program in Dec. 2007. The original purpose of the program is listening to the feedbacks and suggestions about Office 2007 so that we can improve our product.

     

    The program has ended in Nov. 2009, which Chaitanya-MSFT has announced in the following thread, http://social.msdn.microsoft.com/Forums/en/innovateonoffice/thread/4fc4c293-513d-495e-907e-e3f59d02e716.

     

    However, there are still many questions/topics raised everyday about the Office general programming in this forum. So, in order to meet this need of the community, we are creating a new forum titled “General Office Development” that will round out the Microsoft Office for Developers Category on MSDN.  As part of this change, we will archive the old “Innovate on Office” forum so that it is read-only, though moderators will be able to move particularly helpful/relevant threads and any new unanswered threads from the old forum to the new.

     

    For general Office development questions and/or questions that don’t fit in the current Access, Excel, Outlook, Word, Open XML, or Visual Studio Tools for Office forums, please use this new General Office Development forum going forward.

Installing and Registering Visual Studio Express Editions announcements

LightSwitch in Visual Studio 2012 RC announcements

LINQ to SQL (Pre-Release) announcements

  • Link
    LINQ to SQL changes in .NET 4.0
    Damien Guard

    Performance

    • Query plans are reused more often by specifically defining text parameter lengths
    • Identity cache lookups for primary key with single result now includes query.Where(predicate).Single()/SingleOrDefault/First/FirstOrDefault
    • Reduced query execution overhead when DataLoadOptions specified (cache lookup considers DataLoadOptions value equivalency – post beta 1)

    Usability

    • ITable<T> interface for additional mocking possibilities
    • Contains with enums automatically casts to int or string depending on column type
    • Associations can now specify non-primary-key columns on the other end of the association
    • Support list initialization syntax for queries
    • LinqDataSource now supports inherited entities
    • LinqDataSource support for Dynamic Data query extenders added

    Query stability

    • Contains now detects self-referencing IQueryable and doesn't cause a stack overflow
    • Skip(0) no longer prevents eager loading
    • GetCommand operates within SQL Compact transactions
    • Exposing Link<T> on a property/field is detected and reported correctly
    • Compiled queries now correctly detect a change in mapping source and throw
    • String.StartsWith, EndsWith and Contains now correctly handles ~ in the search string
    • Now detects multiple active result sets (MARS) better
    • Associations are properly created between entities when using eager loading with Table-Valued Functions (TVFs)
    • Queries that contain sub-queries with scalar projections now work better

    Update stability

    • SubmitChanges no longer silently consumes transaction rollback exceptions
    • SubmitChanges deals with timestamps in a change conflict scenario properly
    • IsDbGenerated now honors renamed properties that don't match underlying column name
    • Server-generated columns and SQL replication/triggers now work instead of throwing SQL exception 

    General stability

    • Binary types equate correctly after deserialization
    • EntitySet.ListChanged fired when adding items to an unloaded entity set
    • Dispose our connections upon context disposal (ones passed in are untouched)

    SQL Metal

    • Foreign key property setter now checks all affected associations not just the first
    • Improved error handling when primary key type not supported
    • Now skips stored procedures containing table-valued parameters instead of aborting process
    • Can now be used against connections that use AttachDbFilename syntax
    • No longer crashes when unexpected data types are encountered

    LINQ to SQL class designer

    • Now handles a single anonymously named column in SQL result set
    • Improved error message for associations to nullable unique columns
    • No longer fails when using clauses are added to the partial user class
    • VarChar(1) now correctly maps to string and not char
    • Decimal precision and scale are now emitted correctly in the DbType attributes for stored procedures
    • Foreign key changes will be picked up when bringing tables back into the designer without a restart 

    Code generation (SQL Metal + LINQ to SQL class designer)

    • Stored procedures using original values now compiles when the entity and context namespaces differ
    • Virtual internal now generates correct syntax
    • Mapping attributes are now fully qualified to prevent conflicts with user types
    • KnownTypeAttributes are now emitted for DataContractSerializer with inheritance
    • Delay-loaded foreign keys now have the correct, compilable, code generated
    • Using stored procedures with concurrency no longer gets confused if entities in different namespace to context
    • ForeignKeyReferenceAlreadyHasValueException is now thrown if any association is loaded not just the first

LightSwitch HTML Client Preview announcements

Found 15841 threads
Announcement: 6

Innovate on Office announcements

  • Link
    Annoucement of the Innovate on Office forum archivement
    Ji.Zhou

    Hello forum users,

     

    This forum was created for the Innovate on Office 2007 program in Dec. 2007. The original purpose of the program is listening to the feedbacks and suggestions about Office 2007 so that we can improve our product.

     

    The program has ended in Nov. 2009, which Chaitanya-MSFT has announced in the following thread, http://social.msdn.microsoft.com/Forums/en/innovateonoffice/thread/4fc4c293-513d-495e-907e-e3f59d02e716.

     

    However, there are still many questions/topics raised everyday about the Office general programming in this forum. So, in order to meet this need of the community, we are creating a new forum titled “General Office Development” that will round out the Microsoft Office for Developers Category on MSDN.  As part of this change, we will archive the old “Innovate on Office” forum so that it is read-only, though moderators will be able to move particularly helpful/relevant threads and any new unanswered threads from the old forum to the new.

     

    For general Office development questions and/or questions that don’t fit in the current Access, Excel, Outlook, Word, Open XML, or Visual Studio Tools for Office forums, please use this new General Office Development forum going forward.

Installing and Registering Visual Studio Express Editions announcements

LightSwitch in Visual Studio 2012 RC announcements

LINQ to SQL (Pre-Release) announcements

  • Link
    LINQ to SQL changes in .NET 4.0
    Damien Guard

    Performance

    • Query plans are reused more often by specifically defining text parameter lengths
    • Identity cache lookups for primary key with single result now includes query.Where(predicate).Single()/SingleOrDefault/First/FirstOrDefault
    • Reduced query execution overhead when DataLoadOptions specified (cache lookup considers DataLoadOptions value equivalency – post beta 1)

    Usability

    • ITable<T> interface for additional mocking possibilities
    • Contains with enums automatically casts to int or string depending on column type
    • Associations can now specify non-primary-key columns on the other end of the association
    • Support list initialization syntax for queries
    • LinqDataSource now supports inherited entities
    • LinqDataSource support for Dynamic Data query extenders added

    Query stability

    • Contains now detects self-referencing IQueryable and doesn't cause a stack overflow
    • Skip(0) no longer prevents eager loading
    • GetCommand operates within SQL Compact transactions
    • Exposing Link<T> on a property/field is detected and reported correctly
    • Compiled queries now correctly detect a change in mapping source and throw
    • String.StartsWith, EndsWith and Contains now correctly handles ~ in the search string
    • Now detects multiple active result sets (MARS) better
    • Associations are properly created between entities when using eager loading with Table-Valued Functions (TVFs)
    • Queries that contain sub-queries with scalar projections now work better

    Update stability

    • SubmitChanges no longer silently consumes transaction rollback exceptions
    • SubmitChanges deals with timestamps in a change conflict scenario properly
    • IsDbGenerated now honors renamed properties that don't match underlying column name
    • Server-generated columns and SQL replication/triggers now work instead of throwing SQL exception 

    General stability

    • Binary types equate correctly after deserialization
    • EntitySet.ListChanged fired when adding items to an unloaded entity set
    • Dispose our connections upon context disposal (ones passed in are untouched)

    SQL Metal

    • Foreign key property setter now checks all affected associations not just the first
    • Improved error handling when primary key type not supported
    • Now skips stored procedures containing table-valued parameters instead of aborting process
    • Can now be used against connections that use AttachDbFilename syntax
    • No longer crashes when unexpected data types are encountered

    LINQ to SQL class designer

    • Now handles a single anonymously named column in SQL result set
    • Improved error message for associations to nullable unique columns
    • No longer fails when using clauses are added to the partial user class
    • VarChar(1) now correctly maps to string and not char
    • Decimal precision and scale are now emitted correctly in the DbType attributes for stored procedures
    • Foreign key changes will be picked up when bringing tables back into the designer without a restart 

    Code generation (SQL Metal + LINQ to SQL class designer)

    • Stored procedures using original values now compiles when the entity and context namespaces differ
    • Virtual internal now generates correct syntax
    • Mapping attributes are now fully qualified to prevent conflicts with user types
    • KnownTypeAttributes are now emitted for DataContractSerializer with inheritance
    • Delay-loaded foreign keys now have the correct, compilable, code generated
    • Using stored procedures with concurrency no longer gets confused if entities in different namespace to context
    • ForeignKeyReferenceAlreadyHasValueException is now thrown if any association is loaded not just the first

LightSwitch HTML Client Preview announcements