Re: Problem with updating MDF Data file as opposed to updating a running SQL Server DB



I don't know if you guys know what I am doing.

In Visual C# Express, I created a windows application, then "Added" a
"Database File". Doing this created an MDF file in my project folder,
and added in a connection string into my "App.config" file for me. This
connection string specifically pointed to data file, and added the
database into my database explorer window in the IDE. From there I
could create a new Data Access Layer (xsd) with a simple drag and drop
and viola, I had a typed dataset for the table in the DB. I have
watched some Atlas tutorials that microsoft provides where they have
done exactly this, but through VWD Express, and not VC# Express.

It would seem with this option, then one could use a SQL Server MDF
file and NOT have to have SQL Server running on the target machine. It
would seem that MS is trying to give people the option to use SQL
Server MDF files instead of MS Access MDB files from the get go on
their development project, with the option to host the MDF files in an
actual instance of SQL Server later down the line.

I am actually going to just use the "SaveXML" and "ReadXML" methods off
of the typed dataset that the IDE created for me, but it is still kinda
ghetto that Microsoft gives you the option to use an MDF file, but it
doesn't work fully....

AB

.



Relevant Pages

  • Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
    ... Your backup is from a different version of Windows SharePoint Services and ... SQL Server 2005 is available. ... The advantages of the embedded version ("Windows Internal Database") over ...
    (microsoft.public.sharepoint.windowsservices)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: "Hidden" Replication Stored Procedures?
    ... Since the engine has hooks that hide the mssqlsystemresource database from ... 4.)Start the SQL Server service; ... Chris Jones ... aforementioned MDF file in Notepad and doing a quick search, ...
    (microsoft.public.sqlserver.replication)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • RE: Executing a DTS package from a Web application.
    ... >> I’ve been only able to find examples of Windows and VB applications. ... >> to a SQL Server database table. ... The SQL Server database is not local. ... the DTS package specifies the full UNC file name. ...
    (microsoft.public.sqlserver.dts)