Uziel fucked around with this message at 18:47 on Dec 16, 2010

fletcher fucked around with this message at 20:48 on Dec 16, 2010

 For intCount = 1 To intMonths
                        'Calculate the interest for this period
                        dblInterest = IPmt(dblAnnualRate / dblMONTHS_YEAR, intCount, intMonths, -dblLoan)

                        'Calculate the principal for this period.
                        dblPrincipal = PPmt(dblAnnualRate / dblMONTHS_YEAR, intCount, intMonths, -dblLoan)

ButterChugger fucked around with this message at 00:26 on Dec 17, 2010

using (var db = new DbDataContext())
{
	try
	{
		db.Connection.Open();
		db.Transaction = db.Connection.BeginTransaction(IsolationLevel.Serializable);
		
		using (var command = db.Connection.CreateCommand())
		{
			command.Transaction = db.Transaction;
			command.CommandText = File.ReadAllText("/path/to/file.sql");
			command.ExecuteNonQuery();
		}
		
		db.Transaction.Commit();
	}
	catch (Exception e)
	{
		db.Transaction.Rollback();
		throw e;
	}
	finally
	{
		db.Connection.Close();
	}
}

SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO

PRINT N'Creating [dbo].[Plants]'
GO
CREATE TABLE [dbo].[Plants]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[AddressId] [int] NULL,
[Name] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL
)
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating primary key [PK_Plants] on [dbo].[Plants]'
GO
ALTER TABLE [dbo].[Plants] ADD CONSTRAINT [PK_Plants] PRIMARY KEY CLUSTERED  ([Id])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating index [IX_PlantName] on [dbo].[Plants]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_PlantName] ON [dbo].[Plants] ([Name])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO

PRINT N'Creating [dbo].[Drivers]'
...

epswing fucked around with this message at 17:56 on Dec 17, 2010

raminasi fucked around with this message at 03:04 on Dec 19, 2010

[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Users")]
public partial class User
{
    private int _Id;
    
    [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Id", AutoSync=AutoSync.OnInsert, 
                       DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
    public int Id
    {
        get
        {
            return this._Id;
        }
        set
        {
            this._Id = value;
        }
    }
    
    // lots more generated code here for other columns
}

public abstract class CrudEntity
{
    public abstract int Pk { get; }
}

public partial class User : CrudEntity
{
    public override int Pk { get { return Id; } }
}

public class CrudService<Entity> where Entity : CrudEntity, new()
{
    protected Entity GetEntity(int id)
    {
        var db = new DbDataContext();
        return db.GetTable<Entity>().SingleOrDefault<Entity>(x => x.Pk == id);
    }
    
    // other crud-like operations here
}

public class UserService : CrudService<User>
{
    // user-specific operations here
}

var userService = new UserService();
var user = userService.GetEntity(42);

return db.Users.SingleOrDefault(x => x.Id == id);

epswing fucked around with this message at 19:52 on Dec 20, 2010