MantisBT - MPfm
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000152MPfmLibrarypublic2011-11-06 07:092011-11-06 12:01
Reporterycastonguay 
Assigned Toycastonguay 
PriorityurgentSeverityfeatureReproducibilityN/A
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version 
Target Version0.5.0.0Fixed in Version0.5.0.0 
Summary0000152: Replace Entity Framework by simple gateway classes (migration to .NET 4.0)
DescriptionThe company which used to make the SQLite data adapter for .NET stopped updating the adapter and it doesn't support .NET 4.0.

The community has taken back the project and have added support for .NET 4.0 but they dropped design-time support for Visual Studio temporarily until they revamp it. This means that Entity Framework isn't supported :-(

After all Entity Framework was overkill for MPfm; using simple gateway classes might be faster than EF after all.

This is related to the Migration to .NET 4.0 issue.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
related to 0000153resolved ycastonguay Migration to .NET 4.0 
related to 0000155resolved ycastonguay Upgrade System.Data.SQLite from 1.0.66 to 1.0.76 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-11-06 07:09ycastonguayNew Issue
2011-11-06 07:09ycastonguayStatusnew => assigned
2011-11-06 07:09ycastonguayAssigned To => ycastonguay
2011-11-06 07:10ycastonguayRelationship addedrelated to 0000153
2011-11-06 07:30svnCheckin
2011-11-06 07:30svnNote Added: 0000158
2011-11-06 08:19svnCheckin
2011-11-06 08:19svnNote Added: 0000160
2011-11-06 08:34svnCheckin
2011-11-06 08:34svnNote Added: 0000162
2011-11-06 10:32svnCheckin
2011-11-06 10:32svnNote Added: 0000164
2011-11-06 11:17svnCheckin
2011-11-06 11:17svnNote Added: 0000165
2011-11-06 11:26svnCheckin
2011-11-06 11:26svnNote Added: 0000166
2011-11-06 11:32svnCheckin
2011-11-06 11:32svnNote Added: 0000167
2011-11-06 11:47ycastonguayRelationship addedrelated to 0000155
2011-11-06 12:01svnCheckin
2011-11-06 12:01svnNote Added: 0000170
2011-11-06 12:01ycastonguayStatusassigned => resolved
2011-11-06 12:01ycastonguayFixed in Version => 0.5.0.0
2011-11-06 12:01ycastonguayResolutionopen => fixed

Notes
(0000158)
svn   
2011-11-06 07:30   
The user admin has checked in files related to this issue (revision 84).

Comment:
MPfm 0.5.0.0 alpha
- Added the SQLiteGateway and MPfmGateway classes. This implements the Gateway design pattern to access data.
- Added the ConvertDTO.Songs method which converts a DataTable into a list of SongDTO.

Related to issue 0000152 and issue 0000153.

Files modified:
U MPfm/branches/current/MPfm/Other Screens/frmSettings.cs
U MPfm/branches/current/MPfm.Library/DTO/ConvertDTO.cs
U MPfm/branches/current/MPfm.Library/DTO/SongDTO.cs
A MPfm/branches/current/MPfm.Library/Data/MPfmGateway.cs
A MPfm/branches/current/MPfm.Library/Data/SQLiteGateway.cs
U MPfm/branches/current/MPfm.Library/MPfm.Library.csproj
(0000160)
svn   
2011-11-06 08:19   
The user admin has checked in files related to this issue (revision 85).

Comment:
MPfm 0.5.0.0 alpha
- Now insert/update/delete songs now working using the old fashioned way!

Related to issue 0000152 and issue 0000153.

Files modified:
U MPfm/branches/current/MPfm/Other Screens/frmSettings.cs
U MPfm/branches/current/MPfm.Library/DTO/ConvertDTO.cs
U MPfm/branches/current/MPfm.Library/Data/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/Data/SQLiteGateway.cs
(0000162)
svn   
2011-11-06 08:34   
The user admin has checked in files related to this issue (revision 86).

Comment:
MPfm 0.5.0.0 alpha
- Moved MPfmGateway insert/update/delete code into SQLiteGateway. The MPfmGateway is now using minimal code! Nice.

Related to issue 0000152 and issue 0000153.

Files modified:
U MPfm/branches/current/MPfm.Library/DTO/ConvertDTO.cs
U MPfm/branches/current/MPfm.Library/Data/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/Data/SQLiteGateway.cs
(0000164)
svn   
2011-11-06 10:32   
The user admin has checked in files related to this issue (revision 87).

Comment:
MPfm 0.5.0.0 alpha
- All methods related to songs are now gone in DataAccess and now implemented in MPfmGateway!

Related to issue 0000152.

Files modified:
U MPfm/branches/current/MPfm/Other Screens/frmSettings.cs
U MPfm/branches/current/MPfm/frmMain.cs
U MPfm/branches/current/MPfm.Library/DTO/ConvertDTO.cs
U MPfm/branches/current/MPfm.Library/Data/DataAccess.cs
U MPfm/branches/current/MPfm.Library/Data/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/Data/SQLiteGateway.cs
U MPfm/branches/current/MPfm.Library/Library.cs
U MPfm/branches/current/MPfm.Library/Player.cs
U MPfm/branches/current/TestControls/frmMain.cs
(0000165)
svn   
2011-11-06 11:17   
The user admin has checked in files related to this issue (revision 88).

Comment:
MPfm 0.5.0.0 alpha
- Equalizer and Folders are now available in MPfmGateway!

Related to issue 0000152.

Files modified:
U MPfm/branches/current/MPfm/Other Screens/frmEffects.cs
U MPfm/branches/current/MPfm/Other Screens/frmSettings.cs
U MPfm/branches/current/MPfm.Library/DTO/ConvertDTO.cs
A MPfm/branches/current/MPfm.Library/DTO/EqualizerDTO.cs
A MPfm/branches/current/MPfm.Library/DTO/FolderDTO.cs
U MPfm/branches/current/MPfm.Library/Data/DataAccess.cs
U MPfm/branches/current/MPfm.Library/Data/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/Data/SQLiteGateway.cs
U MPfm/branches/current/MPfm.Library/Library.cs
U MPfm/branches/current/MPfm.Library/MPfm.Library.csproj
(0000166)
svn   
2011-11-06 11:26   
The user admin has checked in files related to this issue (revision 89).

Comment:
MPfm 0.5.0.0 alpha
- Deleted DataAccess.cs and finished moving methods into MPfmGateway (except for loops/markers).

Related to issue 0000152.

Files modified:
U MPfm/branches/current/MPfm/Other Screens/frmAddEditLoop.cs
U MPfm/branches/current/MPfm/Other Screens/frmAddEditMarker.cs
U MPfm/branches/current/MPfm/frmMain.cs
U MPfm/branches/current/MPfm.Library/DTO/ConvertDTO.cs
D MPfm/branches/current/MPfm.Library/Data/DataAccess.cs
U MPfm/branches/current/MPfm.Library/Data/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/Data/SQLiteGateway.cs
U MPfm/branches/current/MPfm.Library/Library.cs
U MPfm/branches/current/MPfm.Library/MPfm.Library.csproj
U MPfm/branches/current/MPfm.Library/Player.cs
(0000167)
svn   
2011-11-06 11:32   
The user admin has checked in files related to this issue (revision 90).

Comment:
MPfm 0.5.0.0 alpha
- Removed the Entity Framework diagram completely!

Related to issue 0000152.

Files modified:
U MPfm/branches/current/MPfm/Other Screens/frmAddEditLoop.cs
U MPfm/branches/current/MPfm/Other Screens/frmAddEditMarker.cs
U MPfm/branches/current/MPfm/Other Screens/frmEffects.cs
U MPfm/branches/current/MPfm/Other Screens/frmSettings.cs
U MPfm/branches/current/MPfm/frmMain.cs
U MPfm/branches/current/MPfm.Library/DTO/ConvertDTO.cs
D MPfm/branches/current/MPfm.Library/Data/MPFM_EF.Designer.cs
D MPfm/branches/current/MPfm.Library/Data/MPFM_EF.edmx
U MPfm/branches/current/MPfm.Library/Data/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/Data/SQLiteGateway.cs
U MPfm/branches/current/MPfm.Library/Library.cs
U MPfm/branches/current/MPfm.Library/MPfm.Library.csproj
U MPfm/branches/current/MPfm.Library/Player.cs
U MPfm/branches/current/MPfm.Library/PlayerV3.cs
U MPfm/branches/current/MPfm.Library/PlayerV4/Player.cs
(0000170)
svn   
2011-11-06 12:01   
The user admin has checked in files related to this issue (revision 93).

Comment:
MPfm 0.5.0.0 alpha
- Migration to .NET 4.0 is COMPLETED! Everything works. Replaced the SQLite assemblies by the new .NET 4.0 assemblies.

Related to issue 0000152 and issue 0000153.

Files modified:
A MPfm/branches/current/MPfm/Lib/SQLite.Interop.dll
U MPfm/branches/current/MPfm/Lib/System.Data.SQLite.Linq.dll
U MPfm/branches/current/MPfm/Lib/System.Data.SQLite.dll
U MPfm/branches/current/MPfm/MPfm.csproj
U MPfm/branches/current/MPfm/app.config
U MPfm/branches/current/MPfm.Core/MPfm.Core.csproj
U MPfm/branches/current/MPfm.Fonts/MPfm.Fonts.csproj
U MPfm/branches/current/MPfm.Library/App.Config
A MPfm/branches/current/MPfm.Library/Lib/SQLite.Interop.dll
U MPfm/branches/current/MPfm.Library/Lib/System.Data.SQLite.Linq.dll
U MPfm/branches/current/MPfm.Library/Lib/System.Data.SQLite.dll
U MPfm/branches/current/MPfm.Library/MPfm.Library.csproj
U MPfm/branches/current/MPfm.Sound/MPfm.Sound.csproj
U MPfm/branches/current/MPfm.WindowsControls/MPfm.WindowsControls.csproj
U MPfm/branches/current/PlaybackEngineV3/App.config
U MPfm/branches/current/PlaybackEngineV3/PlaybackEngineV4.csproj
U MPfm/branches/current/TestControls/TestControls.csproj
U MPfm/branches/current/TestControls/app.config