Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
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.
TagsNo tags attached.
Attached Files

- Relationships
related to 0000153resolvedycastonguay Migration to .NET 4.0 
related to 0000155resolvedycastonguay Upgrade System.Data.SQLite from 1.0.66 to 1.0.76 

-  Notes
(0000158)
svn (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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


- Issue History
Date Modified Username Field Change
2011-11-06 07:09 ycastonguay New Issue
2011-11-06 07:09 ycastonguay Status new => assigned
2011-11-06 07:09 ycastonguay Assigned To => ycastonguay
2011-11-06 07:10 ycastonguay Relationship added related to 0000153
2011-11-06 07:30 svn Checkin
2011-11-06 07:30 svn Note Added: 0000158
2011-11-06 08:19 svn Checkin
2011-11-06 08:19 svn Note Added: 0000160
2011-11-06 08:34 svn Checkin
2011-11-06 08:34 svn Note Added: 0000162
2011-11-06 10:32 svn Checkin
2011-11-06 10:32 svn Note Added: 0000164
2011-11-06 11:17 svn Checkin
2011-11-06 11:17 svn Note Added: 0000165
2011-11-06 11:26 svn Checkin
2011-11-06 11:26 svn Note Added: 0000166
2011-11-06 11:32 svn Checkin
2011-11-06 11:32 svn Note Added: 0000167
2011-11-06 11:47 ycastonguay Relationship added related to 0000155
2011-11-06 12:01 svn Checkin
2011-11-06 12:01 svn Note Added: 0000170
2011-11-06 12:01 ycastonguay Status assigned => resolved
2011-11-06 12:01 ycastonguay Fixed in Version => 0.5.0.0
2011-11-06 12:01 ycastonguay Resolution open => fixed


Copyright © 2000 - 2011 MantisBT Group
Powered by Mantis Bugtracker